home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1999-03-16 | 50.2 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| ChemDraw Template (other/chemDrawTemplate)
| ext
| Unsupported |
| 100%
| file
| data
| default
| |
| 100%
| TrID
| TERSE compressed data (PACK, U)
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 02 00 00 00 02 00 ff ff | 00 00 17 00 78 78 43 6f |........|....xxCo|
|00000010| 6e 74 72 61 63 74 53 75 | 70 70 6f 72 74 53 63 72 |ntractSu|pportScr|
|00000020| 69 70 74 02 00 00 00 1c | 46 69 6c 74 65 72 20 53 |ipt.....|Filter S|
|00000030| 75 70 70 6f 72 74 20 28 | 53 65 72 76 65 72 20 53 |upport (|Server S|
|00000040| 69 64 65 29 ff 3c 17 66 | 75 6e 63 74 69 6f 6e 20 |ide).<.f|unction |
|00000050| 41 64 64 54 6f 46 69 6c | 74 65 72 28 6f 62 6a 52 |AddToFil|ter(objR|
|00000060| 65 63 6f 72 64 73 65 74 | 2c 20 73 74 72 45 6c 65 |ecordset|, strEle|
|00000070| 6d 65 6e 74 4e 61 6d 65 | 2c 20 73 74 72 46 69 65 |mentName|, strFie|
|00000080| 6c 64 4e 61 6d 65 2c 20 | 73 74 72 4f 70 65 72 61 |ldName, |strOpera|
|00000090| 74 6f 72 2c 20 73 74 72 | 43 6f 6e 6e 65 63 74 6f |tor, str|Connecto|
|000000a0| 72 2c 20 73 74 72 45 6c | 65 6d 65 6e 74 54 79 70 |r, strEl|ementTyp|
|000000b0| 65 2c 20 73 74 72 43 6c | 61 75 73 65 53 65 70 61 |e, strCl|auseSepa|
|000000c0| 72 61 74 6f 72 29 0d 0a | 7b 0d 0a 0d 0a 76 61 72 |rator)..|{....var|
|000000d0| 20 73 74 72 56 61 6c 75 | 65 0d 0a 76 61 72 20 64 | strValu|e..var d|
|000000e0| 6f 63 0d 0a 76 61 72 20 | 73 74 72 46 69 6c 74 65 |oc..var |strFilte|
|000000f0| 72 0d 0a 76 61 72 20 73 | 74 72 42 65 67 69 6e 57 |r..var s|trBeginW|
|00000100| 69 6c 64 43 61 72 64 20 | 3d 20 22 22 0d 0a 76 61 |ildCard |= ""..va|
|00000110| 72 20 73 74 72 45 6e 64 | 57 69 6c 64 43 61 72 64 |r strEnd|WildCard|
|00000120| 20 3d 20 22 22 0d 0a 76 | 61 72 20 73 74 72 42 65 | = ""..v|ar strBe|
|00000130| 67 69 6e 43 6c 61 75 73 | 65 20 3d 20 22 22 0d 0a |ginClaus|e = ""..|
|00000140| 76 61 72 20 73 74 72 45 | 6e 64 43 6c 61 75 73 65 |var strE|ndClause|
|00000150| 20 3d 20 22 22 0d 0a 76 | 61 72 20 73 74 72 4c 6f | = ""..v|ar strLo|
|00000160| 63 61 6c 4f 70 65 72 61 | 74 6f 72 20 3d 20 73 74 |calOpera|tor = st|
|00000170| 72 4f 70 65 72 61 74 6f | 72 0d 0a 76 61 72 20 73 |rOperato|r..var s|
|00000180| 74 72 54 61 62 6c 65 4e | 61 6d 65 20 3d 20 22 22 |trTableN|ame = ""|
|00000190| 0d 0a 76 61 72 20 73 74 | 72 43 6f 6c 75 6d 6e 4e |..var st|rColumnN|
|000001a0| 61 6d 65 20 3d 20 22 22 | 0d 0a 76 61 72 20 73 74 |ame = ""|..var st|
|000001b0| 72 54 68 65 46 69 65 6c | 64 4e 61 6d 65 0d 0a 0d |rTheFiel|dName...|
|000001c0| 0a 2f 2f 20 41 6e 61 6c | 79 7a 65 20 74 68 65 20 |.// Anal|yze the |
|000001d0| 66 69 65 6c 64 20 6e 61 | 6d 65 20 66 6f 72 20 74 |field na|me for t|
|000001e0| 61 62 6c 65 20 6e 61 6d | 65 73 20 61 6e 64 20 73 |able nam|es and s|
|000001f0| 70 61 63 65 73 0d 0a 64 | 6f 74 50 6f 73 20 3d 20 |paces..d|otPos = |
|00000200| 73 74 72 46 69 65 6c 64 | 4e 61 6d 65 2e 69 6e 64 |strField|Name.ind|
|00000210| 65 78 4f 66 28 22 2e 22 | 29 0d 0a 69 66 20 28 64 |exOf("."|)..if (d|
|00000220| 6f 74 50 6f 73 20 3e 20 | 30 29 0d 0a 7b 0d 0a 09 |otPos > |0)..{...|
|00000230| 73 74 72 54 61 62 6c 65 | 4e 61 6d 65 20 3d 20 73 |strTable|Name = s|
|00000240| 74 72 46 69 65 6c 64 4e | 61 6d 65 2e 73 75 62 73 |trFieldN|ame.subs|
|00000250| 74 72 69 6e 67 28 30 2c | 64 6f 74 50 6f 73 29 0d |tring(0,|dotPos).|
|00000260| 0a 09 73 74 72 43 6f 6c | 75 6d 6e 4e 61 6d 65 20 |..strCol|umnName |
|00000270| 3d 20 73 74 72 46 69 65 | 6c 64 4e 61 6d 65 2e 73 |= strFie|ldName.s|
|00000280| 75 62 73 74 72 69 6e 67 | 28 64 6f 74 50 6f 73 20 |ubstring|(dotPos |
|00000290| 2b 20 31 2c 20 73 74 72 | 46 69 65 6c 64 4e 61 6d |+ 1, str|FieldNam|
|000002a0| 65 2e 6c 65 6e 67 74 68 | 29 0d 0a 0d 0a 09 69 66 |e.length|).....if|
|000002b0| 20 28 73 74 72 54 61 62 | 6c 65 4e 61 6d 65 2e 69 | (strTab|leName.i|
|000002c0| 6e 64 65 78 4f 66 28 22 | 20 22 29 20 3e 3d 20 30 |ndexOf("| ") >= 0|
|000002d0| 20 26 26 20 73 74 72 54 | 61 62 6c 65 4e 61 6d 65 | && strT|ableName|
|000002e0| 2e 63 68 61 72 41 74 28 | 73 74 72 54 61 62 6c 65 |.charAt(|strTable|
|000002f0| 4e 61 6d 65 2e 6c 65 6e | 67 74 68 20 2d 20 31 29 |Name.len|gth - 1)|
|00000300| 20 21 3d 20 22 5d 22 29 | 0d 0a 09 7b 0d 0a 09 09 | != "]")|...{....|
|00000310| 73 74 72 54 61 62 6c 65 | 4e 61 6d 65 20 3d 20 22 |strTable|Name = "|
|00000320| 5b 22 20 2b 20 73 74 72 | 54 61 62 6c 65 4e 61 6d |[" + str|TableNam|
|00000330| 65 20 2b 20 22 5d 22 0d | 0a 09 7d 0d 0a 0d 0a 09 |e + "]".|..}.....|
|00000340| 73 74 72 54 61 62 6c 65 | 4e 61 6d 65 20 2b 3d 20 |strTable|Name += |
|00000350| 22 2e 22 0d 0a 7d 0d 0a | 65 6c 73 65 0d 0a 7b 0d |"."..}..|else..{.|
|00000360| 0a 09 73 74 72 43 6f 6c | 75 6d 6e 4e 61 6d 65 20 |..strCol|umnName |
|00000370| 3d 20 73 74 72 46 69 65 | 6c 64 4e 61 6d 65 0d 0a |= strFie|ldName..|
|00000380| 7d 0d 0a 0d 0a 69 66 20 | 28 73 74 72 43 6f 6c 75 |}....if |(strColu|
|00000390| 6d 6e 4e 61 6d 65 2e 69 | 6e 64 65 78 4f 66 28 22 |mnName.i|ndexOf("|
|000003a0| 20 22 29 20 3e 3d 20 30 | 20 26 26 20 73 74 72 43 | ") >= 0| && strC|
|000003b0| 6f 6c 75 6d 6e 4e 61 6d | 65 2e 63 68 61 72 41 74 |olumnNam|e.charAt|
|000003c0| 28 73 74 72 43 6f 6c 75 | 6d 6e 4e 61 6d 65 2e 6c |(strColu|mnName.l|
|000003d0| 65 6e 67 74 68 20 2d 20 | 31 29 20 21 3d 20 22 5d |ength - |1) != "]|
|000003e0| 22 29 0d 0a 7b 0d 0a 09 | 73 74 72 43 6f 6c 75 6d |")..{...|strColum|
|000003f0| 6e 4e 61 6d 65 20 3d 20 | 22 5b 22 20 2b 20 73 74 |nName = |"[" + st|
|00000400| 72 43 6f 6c 75 6d 6e 4e | 61 6d 65 20 2b 20 22 5d |rColumnN|ame + "]|
|00000410| 22 0d 0a 7d 0d 0a 0d 0a | 73 74 72 54 68 65 46 69 |"..}....|strTheFi|
|00000420| 65 6c 64 4e 61 6d 65 20 | 3d 20 73 74 72 54 61 62 |eldName |= strTab|
|00000430| 6c 65 4e 61 6d 65 20 2b | 20 73 74 72 43 6f 6c 75 |leName +| strColu|
|00000440| 6d 6e 4e 61 6d 65 0d 0a | 0d 0a 69 66 20 28 73 74 |mnName..|..if (st|
|00000450| 72 43 6c 61 75 73 65 53 | 65 70 61 72 61 74 6f 72 |rClauseS|eparator|
|00000460| 20 3d 3d 20 22 28 22 29 | 0d 0a 7b 0d 0a 20 20 20 | == "(")|..{.. |
|00000470| 20 73 74 72 42 65 67 69 | 6e 43 6c 61 75 73 65 20 | strBegi|nClause |
|00000480| 3d 20 22 28 22 0d 0a 7d | 0d 0a 65 6c 73 65 20 69 |= "("..}|..else i|
|00000490| 66 20 28 73 74 72 43 6c | 61 75 73 65 53 65 70 61 |f (strCl|auseSepa|
|000004a0| 72 61 74 6f 72 20 3d 3d | 20 22 29 22 29 0d 0a 7b |rator ==| ")")..{|
|000004b0| 0d 0a 20 20 20 20 73 74 | 72 45 6e 64 43 6c 61 75 |.. st|rEndClau|
|000004c0| 73 65 20 3d 20 22 29 22 | 0d 0a 7d 0d 0a 0d 0a 69 |se = ")"|..}....i|
|000004d0| 66 20 20 28 73 74 72 43 | 6f 6e 6e 65 63 74 6f 72 |f (strC|onnector|
|000004e0| 20 3d 3d 20 22 20 22 29 | 0d 0a 7b 20 0d 0a 20 20 | == " ")|..{ .. |
|000004f0| 20 20 73 74 72 46 69 6c | 74 65 72 20 3d 20 22 22 | strFil|ter = ""|
|00000500| 0d 0a 7d 20 0d 0a 65 6c | 73 65 0d 0a 7b 0d 0a 09 |..} ..el|se..{...|
|00000510| 69 66 20 28 6f 62 6a 52 | 65 63 6f 72 64 73 65 74 |if (objR|ecordset|
|00000520| 2e 46 69 6c 74 65 72 53 | 74 72 69 6e 67 29 0d 0a |.FilterS|tring)..|
|00000530| 09 7b 0d 0a 09 09 73 74 | 72 46 69 6c 74 65 72 20 |.{....st|rFilter |
|00000540| 3d 20 6f 62 6a 52 65 63 | 6f 72 64 73 65 74 2e 46 |= objRec|ordset.F|
|00000550| 69 6c 74 65 72 53 74 72 | 69 6e 67 0d 0a 09 7d 0d |ilterStr|ing...}.|
|00000560| 0a 09 65 6c 73 65 0d 0a | 09 7b 0d 0a 09 09 73 74 |..else..|.{....st|
|00000570| 72 46 69 6c 74 65 72 20 | 3d 20 22 22 09 09 0d 0a |rFilter |= ""....|
|00000580| 09 7d 0d 0a 20 20 20 20 | 73 74 72 46 69 6c 74 65 |.}.. |strFilte|
|00000590| 72 20 3d 20 53 74 72 69 | 70 46 69 6c 74 65 72 57 |r = Stri|pFilterW|
|000005a0| 72 61 70 28 73 74 72 46 | 69 6c 74 65 72 29 0d 0a |rap(strF|ilter)..|
|000005b0| 7d 0d 0a 0d 0a 0d 0a 69 | 66 20 28 73 74 72 45 6c |}......i|f (strEl|
|000005c0| 65 6d 65 6e 74 54 79 70 | 65 20 3d 3d 20 22 45 64 |ementTyp|e == "Ed|
|000005d0| 69 74 42 6f 78 22 20 7c | 7c 20 73 74 72 45 6c 65 |itBox" ||| strEle|
|000005e0| 6d 65 6e 74 54 79 70 65 | 20 3d 3d 20 22 4c 69 73 |mentType| == "Lis|
|000005f0| 74 42 6f 78 22 29 0d 0a | 7b 0d 0a 20 20 20 20 73 |tBox")..|{.. s|
|00000600| 74 72 56 61 6c 75 65 20 | 3d 20 53 74 72 69 6e 67 |trValue |= String|
|00000610| 28 52 65 71 75 65 73 74 | 28 73 74 72 45 6c 65 6d |(Request|(strElem|
|00000620| 65 6e 74 4e 61 6d 65 29 | 29 0d 0a 7d 0d 0a 65 6c |entName)|)..}..el|
|00000630| 73 65 20 69 66 20 28 73 | 74 72 45 6c 65 6d 65 6e |se if (s|trElemen|
|00000640| 74 54 79 70 65 20 3d 3d | 20 22 56 61 6c 75 65 22 |tType ==| "Value"|
|00000650| 29 0d 0a 7b 0d 0a 20 20 | 20 20 73 74 72 56 61 6c |)..{.. | strVal|
|00000660| 75 65 20 3d 20 73 74 72 | 45 6c 65 6d 65 6e 74 4e |ue = str|ElementN|
|00000670| 61 6d 65 0d 0a 7d 0d 0a | 65 6c 73 65 20 0d 0a 7b |ame..}..|else ..{|
|00000680| 0d 0a 20 20 20 20 69 66 | 20 28 53 74 72 69 6e 67 |.. if| (String|
|00000690| 28 52 65 71 75 65 73 74 | 28 73 74 72 45 6c 65 6d |(Request|(strElem|
|000006a0| 65 6e 74 4e 61 6d 65 29 | 29 20 3d 3d 20 22 75 6e |entName)|) == "un|
|000006b0| 64 65 66 69 6e 65 64 22 | 29 0d 0a 20 20 20 20 7b |defined"|).. {|
|000006c0| 0d 0a 20 20 20 20 20 20 | 20 20 73 74 72 56 61 6c |.. | strVal|
|000006d0| 75 65 20 3d 20 22 66 61 | 6c 73 65 22 0d 0a 20 20 |ue = "fa|lse".. |
|000006e0| 20 20 7d 0d 0a 20 20 20 | 20 65 6c 73 65 0d 0a 20 | }.. | else.. |
|000006f0| 20 20 20 7b 0d 0a 20 20 | 20 20 20 20 20 20 73 74 | {.. | st|
|00000700| 72 56 61 6c 75 65 20 3d | 20 22 74 72 75 65 22 0d |rValue =| "true".|
|00000710| 0a 20 20 20 20 7d 0d 0a | 7d 0d 0a 0d 0a 73 74 72 |. }..|}....str|
|00000720| 56 61 6c 75 65 20 3d 20 | 46 69 6c 74 65 72 53 75 |Value = |FilterSu|
|00000730| 70 70 6f 72 74 45 73 63 | 61 70 65 51 75 6f 74 65 |pportEsc|apeQuote|
|00000740| 73 28 73 74 72 56 61 6c | 75 65 29 0d 0a 0d 0a 0d |s(strVal|ue).....|
|00000750| 0a 69 66 20 28 73 74 72 | 4f 70 65 72 61 74 6f 72 |.if (str|Operator|
|00000760| 20 3d 3d 20 22 42 65 67 | 69 6e 73 20 77 69 74 68 | == "Beg|ins with|
|00000770| 22 29 0d 0a 7b 0d 0a 20 | 20 20 20 73 74 72 45 6e |")..{.. | strEn|
|00000780| 64 57 69 6c 64 43 61 72 | 64 20 3d 20 22 2a 22 0d |dWildCar|d = "*".|
|00000790| 0a 20 20 20 20 73 74 72 | 4c 6f 63 61 6c 4f 70 65 |. str|LocalOpe|
|000007a0| 72 61 74 6f 72 20 3d 20 | 22 4c 49 4b 45 22 0d 0a |rator = |"LIKE"..|
|000007b0| 7d 0d 0a 0d 0a 69 66 20 | 28 73 74 72 4f 70 65 72 |}....if |(strOper|
|000007c0| 61 74 6f 72 20 3d 3d 20 | 22 49 6e 63 6c 75 64 65 |ator == |"Include|
|000007d0| 73 22 29 0d 0a 7b 0d 0a | 20 20 20 20 73 74 72 42 |s")..{..| strB|
|000007e0| 65 67 69 6e 57 69 6c 64 | 43 61 72 64 20 3d 20 22 |eginWild|Card = "|
|000007f0| 2a 22 0d 0a 20 20 20 20 | 73 74 72 45 6e 64 57 69 |*".. |strEndWi|
|00000800| 6c 64 43 61 72 64 20 3d | 20 22 2a 22 0d 0a 20 20 |ldCard =| "*".. |
|00000810| 20 20 73 74 72 4c 6f 63 | 61 6c 4f 70 65 72 61 74 | strLoc|alOperat|
|00000820| 6f 72 20 3d 20 22 4c 49 | 4b 45 22 0d 0a 7d 0d 0a |or = "LI|KE"..}..|
|00000830| 0d 0a 69 66 20 28 73 74 | 72 4f 70 65 72 61 74 6f |..if (st|rOperato|
|00000840| 72 20 3d 3d 20 22 4e 6f | 74 20 65 71 75 61 6c 20 |r == "No|t equal |
|00000850| 74 6f 22 29 0d 0a 7b 0d | 0a 20 20 20 20 73 74 72 |to")..{.|. str|
|00000860| 4c 6f 63 61 6c 4f 70 65 | 72 61 74 6f 72 20 3d 20 |LocalOpe|rator = |
|00000870| 22 3c 3e 22 0d 0a 7d 0d | 0a 0d 0a 69 66 20 28 73 |"<>"..}.|...if (s|
|00000880| 74 72 56 61 6c 75 65 20 | 21 3d 20 22 22 29 0d 0a |trValue |!= "")..|
|00000890| 7b 0d 0a 20 20 20 20 69 | 66 20 28 73 74 72 46 69 |{.. i|f (strFi|
|000008a0| 6c 74 65 72 20 3d 3d 20 | 22 22 29 0d 0a 20 20 20 |lter == |"").. |
|000008b0| 20 7b 0d 0a 20 20 20 20 | 20 20 20 20 2f 2f 20 57 | {.. | // W|
|000008c0| 65 20 64 6f 6e 27 74 20 | 77 61 6e 74 20 74 6f 20 |e don't |want to |
|000008d0| 73 74 61 72 74 20 6f 66 | 66 20 77 69 74 68 20 22 |start of|f with "|
|000008e0| 41 4e 44 22 20 6f 72 20 | 22 4f 52 22 0d 0a 20 20 |AND" or |"OR".. |
|000008f0| 20 20 20 20 20 20 73 74 | 72 43 6f 6e 6e 65 63 74 | st|rConnect|
|00000900| 6f 72 20 3d 20 22 22 0d | 0a 20 20 20 20 7d 0d 0a |or = "".|. }..|
|00000910| 0d 0a 20 20 20 20 73 74 | 72 46 69 6c 74 65 72 20 |.. st|rFilter |
|00000920| 2b 3d 20 22 20 22 20 2b | 20 73 74 72 43 6f 6e 6e |+= " " +| strConn|
|00000930| 65 63 74 6f 72 20 2b 20 | 22 20 22 20 2b 20 73 74 |ector + |" " + st|
|00000940| 72 42 65 67 69 6e 43 6c | 61 75 73 65 20 2b 20 73 |rBeginCl|ause + s|
|00000950| 74 72 54 68 65 46 69 65 | 6c 64 4e 61 6d 65 20 2b |trTheFie|ldName +|
|00000960| 20 22 20 22 20 2b 20 73 | 74 72 4c 6f 63 61 6c 4f | " " + s|trLocalO|
|00000970| 70 65 72 61 74 6f 72 20 | 2b 20 22 20 27 22 20 2b |perator |+ " '" +|
|00000980| 20 73 74 72 42 65 67 69 | 6e 57 69 6c 64 43 61 72 | strBegi|nWildCar|
|00000990| 64 20 2b 20 73 74 72 56 | 61 6c 75 65 20 2b 20 73 |d + strV|alue + s|
|000009a0| 74 72 45 6e 64 57 69 6c | 64 43 61 72 64 20 2b 20 |trEndWil|dCard + |
|000009b0| 22 27 22 20 2b 20 73 74 | 72 45 6e 64 43 6c 61 75 |"'" + st|rEndClau|
|000009c0| 73 65 0d 0a 7d 0d 0a 0d | 0a 73 74 72 46 69 6c 74 |se..}...|.strFilt|
|000009d0| 65 72 20 3d 20 41 64 64 | 46 69 6c 74 65 72 57 72 |er = Add|FilterWr|
|000009e0| 61 70 28 73 74 72 46 69 | 6c 74 65 72 29 0d 0a 0d |ap(strFi|lter)...|
|000009f0| 0a 6f 62 6a 52 65 63 6f | 72 64 73 65 74 2e 46 69 |.objReco|rdset.Fi|
|00000a00| 6c 74 65 72 53 74 72 69 | 6e 67 20 3d 20 73 74 72 |lterStri|ng = str|
|00000a10| 46 69 6c 74 65 72 0d 0a | 0d 0a 2f 2f 52 65 73 70 |Filter..|..//Resp|
|00000a20| 6f 6e 73 65 2e 57 72 69 | 74 65 28 22 3c 62 72 3e |onse.Wri|te("<br>|
|00000a30| 46 69 6c 74 65 72 20 3d | 20 22 20 2b 20 73 74 72 |Filter =| " + str|
|00000a40| 46 69 6c 74 65 72 29 0d | 0a 7d 0d 0a 0d 0a 0d 0a |Filter).|.}......|
|00000a50| 2f 2f 20 54 68 69 73 20 | 66 75 6e 63 74 69 6f 6e |// This |function|
|00000a60| 20 74 61 6b 65 73 20 61 | 20 73 74 72 69 6e 67 0d | takes a| string.|
|00000a70| 0a 2f 2f 20 73 75 63 68 | 20 61 73 20 58 58 58 58 |.// such| as XXXX|
|00000a80| 58 58 20 61 6e 64 20 72 | 65 74 75 72 6e 73 20 46 |XX and r|eturns F|
|00000a90| 69 6c 74 65 72 28 22 58 | 58 58 58 58 58 22 29 0d |ilter("X|XXXXX").|
|00000aa0| 0a 2f 2f 0d 0a 66 75 6e | 63 74 69 6f 6e 20 41 64 |.//..fun|ction Ad|
|00000ab0| 64 46 69 6c 74 65 72 57 | 72 61 70 28 73 74 72 49 |dFilterW|rap(strI|
|00000ac0| 6e 29 0d 0a 7b 0d 0a 20 | 20 20 20 76 61 72 20 73 |n)..{.. | var s|
|00000ad0| 74 72 4f 75 74 0d 0a 0d | 0a 20 20 20 20 73 74 72 |trOut...|. str|
|00000ae0| 4f 75 74 20 3d 20 22 46 | 69 6c 74 65 72 28 5c 22 |Out = "F|ilter(\"|
|00000af0| 22 20 2b 20 73 74 72 49 | 6e 20 2b 20 22 5c 22 29 |" + strI|n + "\")|
|00000b00| 22 0d 0a 0d 0a 20 20 20 | 20 72 65 74 75 72 6e 20 |".... | return |
|00000b10| 73 74 72 4f 75 74 0d 0a | 7d 0d 0a 0d 0a 0d 0a 2f |strOut..|}....../|
|00000b20| 2f 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |/ This f|unction |
|00000b30| 74 61 6b 65 73 20 61 20 | 73 74 72 69 6e 67 0d 0a |takes a |string..|
|00000b40| 2f 2f 20 73 75 63 68 20 | 61 73 20 46 69 6c 74 65 |// such |as Filte|
|00000b50| 72 28 22 58 58 58 58 58 | 58 22 29 20 61 6e 64 20 |r("XXXXX|X") and |
|00000b60| 72 65 74 75 72 6e 73 20 | 58 58 58 58 58 58 0d 0a |returns |XXXXXX..|
|00000b70| 2f 2f 0d 0a 66 75 6e 63 | 74 69 6f 6e 20 53 74 72 |//..func|tion Str|
|00000b80| 69 70 46 69 6c 74 65 72 | 57 72 61 70 28 73 29 0d |ipFilter|Wrap(s).|
|00000b90| 0a 7b 0d 0a 20 20 20 20 | 76 61 72 20 73 74 72 49 |.{.. |var strI|
|00000ba0| 6e 20 3d 20 53 74 72 69 | 6e 67 28 73 29 0d 0a 20 |n = Stri|ng(s).. |
|00000bb0| 20 20 20 76 61 72 20 73 | 74 72 4f 75 74 20 3d 20 | var s|trOut = |
|00000bc0| 22 22 0d 0a 0d 0a 20 20 | 20 20 69 66 20 28 73 74 |"".... | if (st|
|00000bd0| 72 49 6e 20 3d 3d 20 22 | 22 29 0d 0a 20 20 20 20 |rIn == "|").. |
|00000be0| 7b 0d 0a 20 20 20 20 20 | 20 20 20 72 65 74 75 72 |{.. | retur|
|00000bf0| 6e 20 22 22 0d 0a 20 20 | 20 20 7d 0d 0a 0d 0a 20 |n "".. | }.... |
|00000c00| 20 20 20 69 66 20 28 73 | 74 72 49 6e 2e 69 6e 64 | if (s|trIn.ind|
|00000c10| 65 78 4f 66 28 22 46 69 | 6c 74 65 72 28 22 29 20 |exOf("Fi|lter(") |
|00000c20| 3d 3d 20 30 29 0d 0a 20 | 20 20 20 7b 0d 0a 20 20 |== 0).. | {.. |
|00000c30| 20 20 20 20 20 20 2f 2f | 20 54 68 65 72 65 20 69 | //| There i|
|00000c40| 73 20 61 6c 72 65 61 64 | 79 20 61 20 66 69 6c 74 |s alread|y a filt|
|00000c50| 65 72 2c 20 6c 65 74 27 | 73 20 73 74 72 69 70 20 |er, let'|s strip |
|00000c60| 69 74 0d 0a 20 20 20 20 | 20 20 20 20 73 74 72 4f |it.. | strO|
|00000c70| 75 74 20 3d 20 73 74 72 | 49 6e 2e 73 75 62 73 74 |ut = str|In.subst|
|00000c80| 72 69 6e 67 28 38 2c 20 | 73 74 72 49 6e 2e 6c 65 |ring(8, |strIn.le|
|00000c90| 6e 67 74 68 20 2d 20 32 | 29 20 20 20 20 0d 0a 20 |ngth - 2|) .. |
|00000ca0| 20 20 20 7d 0d 0a 20 20 | 20 20 65 6c 73 65 0d 0a | }.. | else..|
|00000cb0| 20 20 20 20 7b 0d 0a 20 | 20 20 20 20 20 20 20 73 | {.. | s|
|00000cc0| 74 72 4f 75 74 20 3d 20 | 73 74 72 49 6e 0d 0a 20 |trOut = |strIn.. |
|00000cd0| 20 20 20 7d 0d 0a 20 20 | 20 20 72 65 74 75 72 6e | }.. | return|
|00000ce0| 20 73 74 72 4f 75 74 0d | 0a 7d 0d 0a 0d 0a 2f 2f | strOut.|.}....//|
|00000cf0| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 74 | This fu|nction t|
|00000d00| 61 6b 65 73 20 61 20 73 | 74 72 69 6e 67 2e 20 20 |akes a s|tring. |
|00000d10| 49 66 20 73 74 72 49 6e | 20 69 73 20 0d 0a 2f 2f |If strIn| is ..//|
|00000d20| 20 48 65 6c 6c 6f 20 22 | 74 68 65 72 65 22 20 68 | Hello "|there" h|
|00000d30| 6f 77 27 73 20 69 74 20 | 67 6f 69 6e 67 3f 0d 0a |ow's it |going?..|
|00000d40| 2f 2f 20 74 68 65 6e 20 | 74 68 69 73 20 66 75 6e |// then |this fun|
|00000d50| 63 74 69 6f 6e 20 77 69 | 6c 6c 20 72 65 74 75 72 |ction wi|ll retur|
|00000d60| 6e 0d 0a 2f 2f 20 48 65 | 6c 6c 6f 20 5c 22 74 68 |n..// He|llo \"th|
|00000d70| 65 72 65 5c 22 20 68 6f | 77 27 27 73 20 69 74 20 |ere\" ho|w''s it |
|00000d80| 67 6f 69 6e 67 3f 0d 0a | 2f 2f 0d 0a 66 75 6e 63 |going?..|//..func|
|00000d90| 74 69 6f 6e 20 46 69 6c | 74 65 72 53 75 70 70 6f |tion Fil|terSuppo|
|00000da0| 72 74 45 73 63 61 70 65 | 51 75 6f 74 65 73 28 73 |rtEscape|Quotes(s|
|00000db0| 74 72 49 6e 29 0d 0a 7b | 0d 0a 20 20 20 20 76 61 |trIn)..{|.. va|
|00000dc0| 72 20 69 0d 0a 20 20 20 | 20 76 61 72 20 74 68 65 |r i.. | var the|
|00000dd0| 43 68 61 72 0d 0a 20 20 | 20 20 76 61 72 20 73 74 |Char.. | var st|
|00000de0| 72 4f 75 74 20 3d 20 22 | 22 0d 0a 20 20 20 20 76 |rOut = "|".. v|
|00000df0| 61 72 20 69 6e 53 74 72 | 69 6e 67 20 3d 20 53 74 |ar inStr|ing = St|
|00000e00| 72 69 6e 67 28 73 74 72 | 49 6e 29 0d 0a 0d 0a 20 |ring(str|In).... |
|00000e10| 20 20 20 66 6f 72 20 28 | 69 20 3d 20 30 3b 20 69 | for (|i = 0; i|
|00000e20| 20 3c 20 69 6e 53 74 72 | 69 6e 67 2e 6c 65 6e 67 | < inStr|ing.leng|
|00000e30| 74 68 3b 20 69 2b 2b 29 | 0d 0a 20 20 20 20 7b 0d |th; i++)|.. {.|
|00000e40| 0a 20 20 20 20 20 20 20 | 20 74 68 65 43 68 61 72 |. | theChar|
|00000e50| 20 3d 20 69 6e 53 74 72 | 69 6e 67 2e 63 68 61 72 | = inStr|ing.char|
|00000e60| 41 74 28 69 29 0d 0a 20 | 20 20 20 20 20 20 20 69 |At(i).. | i|
|00000e70| 66 20 28 74 68 65 43 68 | 61 72 20 3d 3d 20 22 27 |f (theCh|ar == "'|
|00000e80| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |").. | |
|00000e90| 73 74 72 4f 75 74 20 2b | 3d 20 22 27 22 0d 0a 20 |strOut +|= "'".. |
|00000ea0| 20 20 20 20 20 20 20 69 | 66 20 28 74 68 65 43 68 | i|f (theCh|
|00000eb0| 61 72 20 3d 3d 20 27 22 | 27 29 0d 0a 20 20 20 20 |ar == '"|').. |
|00000ec0| 20 20 20 20 20 20 20 20 | 73 74 72 4f 75 74 20 2b | |strOut +|
|00000ed0| 3d 20 22 5c 5c 22 0d 0a | 0d 0a 20 20 20 20 20 20 |= "\\"..|.. |
|00000ee0| 20 20 73 74 72 4f 75 74 | 20 2b 3d 20 74 68 65 43 | strOut| += theC|
|00000ef0| 68 61 72 0d 0a 20 20 20 | 20 7d 0d 0a 20 20 20 20 |har.. | }.. |
|00000f00| 72 65 74 75 72 6e 20 73 | 74 72 4f 75 74 0d 0a 7d |return s|trOut..}|
|00000f10| 0d 0a 0d 0a 0d 0a 2f 2f | 20 54 68 69 73 20 66 75 |......//| This fu|
|00000f20| 6e 63 74 69 6f 6e 20 63 | 72 65 61 74 65 73 20 61 |nction c|reates a|
|00000f30| 20 66 69 6c 74 65 72 20 | 62 61 73 65 64 20 6f 6e | filter |based on|
|00000f40| 20 76 61 6c 75 65 73 20 | 73 75 62 6d 69 74 74 65 | values |submitte|
|00000f50| 64 0d 0a 2f 2f 20 62 79 | 20 61 20 6c 69 73 74 20 |d..// by| a list |
|00000f60| 62 6f 78 2e 20 20 4d 75 | 6c 74 69 70 6c 65 20 76 |box. Mu|ltiple v|
|00000f70| 61 6c 75 65 73 20 74 68 | 61 74 20 61 72 65 20 63 |alues th|at are c|
|00000f80| 6f 6d 6d 61 2d 64 65 6c | 69 6d 69 74 65 64 0d 0a |omma-del|imited..|
|00000f90| 2f 2f 20 61 72 65 20 61 | 63 63 65 70 74 65 64 2e |// are a|ccepted.|
|00000fa0| 20 4e 4f 54 45 3a 20 41 | 6c 6c 20 63 6f 6d 6d 61 | NOTE: A|ll comma|
|00000fb0| 73 20 61 72 65 20 63 6f | 6e 73 69 64 65 72 65 64 |s are co|nsidered|
|00000fc0| 20 64 65 6c 69 6d 69 74 | 65 72 73 2e 0d 0a 2f 2f | delimit|ers...//|
|00000fd0| 0d 0a 66 75 6e 63 74 69 | 6f 6e 20 43 72 65 61 74 |..functi|on Creat|
|00000fe0| 65 4d 75 6c 74 69 4c 69 | 73 74 46 69 6c 74 65 72 |eMultiLi|stFilter|
|00000ff0| 28 73 74 72 45 6c 65 6d | 65 6e 74 4e 61 6d 65 2c |(strElem|entName,|
|00001000| 20 73 74 72 46 69 65 6c | 64 4e 61 6d 65 2c 20 73 | strFiel|dName, s|
|00001010| 74 72 4f 70 65 72 61 74 | 6f 72 29 0d 0a 7b 0d 0a |trOperat|or)..{..|
|00001020| 0d 0a 76 61 72 20 73 74 | 72 56 61 6c 75 65 0d 0a |..var st|rValue..|
|00001030| 76 61 72 20 74 68 69 73 | 56 61 6c 0d 0a 76 61 72 |var this|Val..var|
|00001040| 20 64 6f 63 0d 0a 76 61 | 72 20 73 74 72 46 69 6c | doc..va|r strFil|
|00001050| 74 65 72 0d 0a 76 61 72 | 20 73 74 72 42 65 67 69 |ter..var| strBegi|
|00001060| 6e 57 69 6c 64 43 61 72 | 64 20 3d 20 22 22 0d 0a |nWildCar|d = ""..|
|00001070| 76 61 72 20 73 74 72 45 | 6e 64 57 69 6c 64 43 61 |var strE|ndWildCa|
|00001080| 72 64 20 3d 20 22 22 0d | 0a 76 61 72 20 73 74 72 |rd = "".|.var str|
|00001090| 4c 6f 63 61 6c 4f 70 65 | 72 61 74 6f 72 20 3d 20 |LocalOpe|rator = |
|000010a0| 73 74 72 4f 70 65 72 61 | 74 6f 72 0d 0a 76 61 72 |strOpera|tor..var|
|000010b0| 20 73 74 72 54 61 62 6c | 65 4e 61 6d 65 20 3d 20 | strTabl|eName = |
|000010c0| 22 22 0d 0a 76 61 72 20 | 73 74 72 43 6f 6c 75 6d |""..var |strColum|
|000010d0| 6e 4e 61 6d 65 20 3d 20 | 22 22 0d 0a 76 61 72 20 |nName = |""..var |
|000010e0| 73 74 72 54 68 65 46 69 | 65 6c 64 4e 61 6d 65 0d |strTheFi|eldName.|
|000010f0| 0a 76 61 72 20 64 6f 74 | 50 6f 73 0d 0a 76 61 72 |.var dot|Pos..var|
|00001100| 20 69 0d 0a 0d 0a 2f 2f | 20 41 6e 61 6c 79 7a 65 | i....//| Analyze|
|00001110| 20 74 68 65 20 66 69 65 | 6c 64 20 6e 61 6d 65 20 | the fie|ld name |
|00001120| 66 6f 72 20 74 61 62 6c | 65 20 6e 61 6d 65 73 20 |for tabl|e names |
|00001130| 61 6e 64 20 73 70 61 63 | 65 73 0d 0a 64 6f 74 50 |and spac|es..dotP|
|00001140| 6f 73 20 3d 20 73 74 72 | 46 69 65 6c 64 4e 61 6d |os = str|FieldNam|
|00001150| 65 2e 69 6e 64 65 78 4f | 66 28 22 2e 22 29 0d 0a |e.indexO|f(".")..|
|00001160| 69 66 20 28 64 6f 74 50 | 6f 73 20 3e 20 30 29 0d |if (dotP|os > 0).|
|00001170| 0a 7b 0d 0a 09 73 74 72 | 54 61 62 6c 65 4e 61 6d |.{...str|TableNam|
|00001180| 65 20 3d 20 73 74 72 46 | 69 65 6c 64 4e 61 6d 65 |e = strF|ieldName|
|00001190| 2e 73 75 62 73 74 72 69 | 6e 67 28 30 2c 64 6f 74 |.substri|ng(0,dot|
|000011a0| 50 6f 73 29 0d 0a 09 73 | 74 72 43 6f 6c 75 6d 6e |Pos)...s|trColumn|
|000011b0| 4e 61 6d 65 20 3d 20 73 | 74 72 46 69 65 6c 64 4e |Name = s|trFieldN|
|000011c0| 61 6d 65 2e 73 75 62 73 | 74 72 69 6e 67 28 64 6f |ame.subs|tring(do|
|000011d0| 74 50 6f 73 20 2b 20 31 | 2c 20 73 74 72 46 69 65 |tPos + 1|, strFie|
|000011e0| 6c 64 4e 61 6d 65 2e 6c | 65 6e 67 74 68 29 0d 0a |ldName.l|ength)..|
|000011f0| 0d 0a 09 69 66 20 28 73 | 74 72 54 61 62 6c 65 4e |...if (s|trTableN|
|00001200| 61 6d 65 2e 69 6e 64 65 | 78 4f 66 28 22 20 22 29 |ame.inde|xOf(" ")|
|00001210| 20 3e 3d 20 30 20 26 26 | 20 73 74 72 54 61 62 6c | >= 0 &&| strTabl|
|00001220| 65 4e 61 6d 65 2e 63 68 | 61 72 41 74 28 73 74 72 |eName.ch|arAt(str|
|00001230| 54 61 62 6c 65 4e 61 6d | 65 2e 6c 65 6e 67 74 68 |TableNam|e.length|
|00001240| 20 2d 20 31 29 20 21 3d | 20 22 5d 22 29 0d 0a 09 | - 1) !=| "]")...|
|00001250| 7b 0d 0a 09 09 73 74 72 | 54 61 62 6c 65 4e 61 6d |{....str|TableNam|
|00001260| 65 20 3d 20 22 5b 22 20 | 2b 20 73 74 72 54 61 62 |e = "[" |+ strTab|
|00001270| 6c 65 4e 61 6d 65 20 2b | 20 22 5d 22 0d 0a 09 7d |leName +| "]"...}|
|00001280| 0d 0a 0d 0a 09 73 74 72 | 54 61 62 6c 65 4e 61 6d |.....str|TableNam|
|00001290| 65 20 2b 3d 20 22 2e 22 | 0d 0a 7d 0d 0a 65 6c 73 |e += "."|..}..els|
|000012a0| 65 0d 0a 7b 0d 0a 09 73 | 74 72 43 6f 6c 75 6d 6e |e..{...s|trColumn|
|000012b0| 4e 61 6d 65 20 3d 20 73 | 74 72 46 69 65 6c 64 4e |Name = s|trFieldN|
|000012c0| 61 6d 65 0d 0a 7d 0d 0a | 0d 0a 69 66 20 28 73 74 |ame..}..|..if (st|
|000012d0| 72 43 6f 6c 75 6d 6e 4e | 61 6d 65 2e 69 6e 64 65 |rColumnN|ame.inde|
|000012e0| 78 4f 66 28 22 20 22 29 | 20 3e 3d 20 30 20 26 26 |xOf(" ")| >= 0 &&|
|000012f0| 20 73 74 72 43 6f 6c 75 | 6d 6e 4e 61 6d 65 2e 63 | strColu|mnName.c|
|00001300| 68 61 72 41 74 28 73 74 | 72 43 6f 6c 75 6d 6e 4e |harAt(st|rColumnN|
|00001310| 61 6d 65 2e 6c 65 6e 67 | 74 68 20 2d 20 31 29 20 |ame.leng|th - 1) |
|00001320| 21 3d 20 22 5d 22 29 0d | 0a 7b 0d 0a 09 73 74 72 |!= "]").|.{...str|
|00001330| 43 6f 6c 75 6d 6e 4e 61 | 6d 65 20 3d 20 22 5b 22 |ColumnNa|me = "["|
|00001340| 20 2b 20 73 74 72 43 6f | 6c 75 6d 6e 4e 61 6d 65 | + strCo|lumnName|
|00001350| 20 2b 20 22 5d 22 0d 0a | 7d 0d 0a 0d 0a 73 74 72 | + "]"..|}....str|
|00001360| 54 68 65 46 69 65 6c 64 | 4e 61 6d 65 20 3d 20 73 |TheField|Name = s|
|00001370| 74 72 54 61 62 6c 65 4e | 61 6d 65 20 2b 20 73 74 |trTableN|ame + st|
|00001380| 72 43 6f 6c 75 6d 6e 4e | 61 6d 65 0d 0a 0d 0a 73 |rColumnN|ame....s|
|00001390| 74 72 46 69 6c 74 65 72 | 20 3d 20 22 22 0d 0a 73 |trFilter| = ""..s|
|000013a0| 74 72 56 61 6c 75 65 20 | 3d 20 53 74 72 69 6e 67 |trValue |= String|
|000013b0| 28 52 65 71 75 65 73 74 | 28 73 74 72 45 6c 65 6d |(Request|(strElem|
|000013c0| 65 6e 74 4e 61 6d 65 29 | 29 0d 0a 69 66 20 28 73 |entName)|)..if (s|
|000013d0| 74 72 56 61 6c 75 65 20 | 3d 3d 20 22 75 6e 64 65 |trValue |== "unde|
|000013e0| 66 69 6e 65 64 22 29 0d | 0a 7b 0d 0a 20 20 20 20 |fined").|.{.. |
|000013f0| 72 65 74 75 72 6e 20 22 | 46 69 6c 74 65 72 28 5c |return "|Filter(\|
|00001400| 22 5c 22 29 22 0d 0a 7d | 0d 0a 0d 0a 73 74 72 56 |"\")"..}|....strV|
|00001410| 61 6c 75 65 20 3d 20 46 | 69 6c 74 65 72 53 75 70 |alue = F|ilterSup|
|00001420| 70 6f 72 74 45 73 63 61 | 70 65 51 75 6f 74 65 73 |portEsca|peQuotes|
|00001430| 28 73 74 72 56 61 6c 75 | 65 29 0d 0a 0d 0a 69 66 |(strValu|e)....if|
|00001440| 20 28 73 74 72 4f 70 65 | 72 61 74 6f 72 20 3d 3d | (strOpe|rator ==|
|00001450| 20 22 42 65 67 69 6e 73 | 20 77 69 74 68 22 29 0d | "Begins| with").|
|00001460| 0a 7b 0d 0a 20 20 20 20 | 73 74 72 45 6e 64 57 69 |.{.. |strEndWi|
|00001470| 6c 64 43 61 72 64 20 3d | 20 22 2a 22 0d 0a 20 20 |ldCard =| "*".. |
|00001480| 20 20 73 74 72 4c 6f 63 | 61 6c 4f 70 65 72 61 74 | strLoc|alOperat|
|00001490| 6f 72 20 3d 20 22 4c 49 | 4b 45 22 0d 0a 7d 0d 0a |or = "LI|KE"..}..|
|000014a0| 0d 0a 69 66 20 28 73 74 | 72 4f 70 65 72 61 74 6f |..if (st|rOperato|
|000014b0| 72 20 3d 3d 20 22 49 6e | 63 6c 75 64 65 73 22 29 |r == "In|cludes")|
|000014c0| 0d 0a 7b 0d 0a 20 20 20 | 20 73 74 72 42 65 67 69 |..{.. | strBegi|
|000014d0| 6e 57 69 6c 64 43 61 72 | 64 20 3d 20 22 2a 22 0d |nWildCar|d = "*".|
|000014e0| 0a 20 20 20 20 73 74 72 | 45 6e 64 57 69 6c 64 43 |. str|EndWildC|
|000014f0| 61 72 64 20 3d 20 22 2a | 22 0d 0a 20 20 20 20 73 |ard = "*|".. s|
|00001500| 74 72 4c 6f 63 61 6c 4f | 70 65 72 61 74 6f 72 20 |trLocalO|perator |
|00001510| 3d 20 22 4c 49 4b 45 22 | 0d 0a 7d 0d 0a 0d 0a 69 |= "LIKE"|..}....i|
|00001520| 66 20 28 73 74 72 4f 70 | 65 72 61 74 6f 72 20 3d |f (strOp|erator =|
|00001530| 3d 20 22 4e 6f 74 20 65 | 71 75 61 6c 20 74 6f 22 |= "Not e|qual to"|
|00001540| 29 0d 0a 7b 0d 0a 20 20 | 20 20 73 74 72 4c 6f 63 |)..{.. | strLoc|
|00001550| 61 6c 4f 70 65 72 61 74 | 6f 72 20 3d 20 22 3c 3e |alOperat|or = "<>|
|00001560| 22 0d 0a 7d 0d 0a 0d 0a | 2f 2f 20 4c 65 74 27 73 |"..}....|// Let's|
|00001570| 20 69 74 65 72 61 74 65 | 20 74 68 72 6f 75 67 68 | iterate| through|
|00001580| 20 74 68 65 20 6c 69 73 | 74 20 61 6e 64 20 63 72 | the lis|t and cr|
|00001590| 65 61 74 65 20 74 68 65 | 20 66 69 6c 74 65 72 20 |eate the| filter |
|000015a0| 73 74 72 69 6e 67 0d 0a | 0d 0a 76 61 6c 75 65 73 |string..|..values|
|000015b0| 20 3d 20 73 74 72 56 61 | 6c 75 65 2e 73 70 6c 69 | = strVa|lue.spli|
|000015c0| 74 28 22 2c 22 29 0d 0a | 0d 0a 73 74 72 46 69 6c |t(",")..|..strFil|
|000015d0| 74 65 72 20 3d 20 22 22 | 0d 0a 0d 0a 66 6f 72 20 |ter = ""|....for |
|000015e0| 28 69 20 3d 20 30 3b 20 | 69 20 3c 20 76 61 6c 75 |(i = 0; |i < valu|
|000015f0| 65 73 2e 6c 65 6e 67 74 | 68 3b 20 69 2b 2b 29 0d |es.lengt|h; i++).|
|00001600| 0a 7b 09 0d 0a 09 74 68 | 69 73 56 61 6c 20 3d 20 |.{....th|isVal = |
|00001610| 76 61 6c 75 65 73 5b 69 | 5d 0d 0a 09 69 66 20 28 |values[i|]...if (|
|00001620| 69 20 3e 20 30 29 0d 0a | 09 7b 0d 0a 20 20 2f 2f |i > 0)..|.{.. //|
|00001630| 20 57 65 20 77 69 6c 6c | 20 73 74 72 69 70 20 74 | We will| strip t|
|00001640| 68 65 20 73 70 61 63 65 | 20 6f 66 66 20 74 68 65 |he space| off the|
|00001650| 20 66 72 6f 6e 74 0d 0a | 09 09 74 68 69 73 56 61 | front..|..thisVa|
|00001660| 6c 20 3d 20 74 68 69 73 | 56 61 6c 2e 73 75 62 73 |l = this|Val.subs|
|00001670| 74 72 69 6e 67 28 31 2c | 74 68 69 73 56 61 6c 2e |tring(1,|thisVal.|
|00001680| 6c 65 6e 67 74 68 29 0d | 0a 09 7d 0d 0a 0d 0a 09 |length).|..}.....|
|00001690| 73 74 72 46 69 6c 74 65 | 72 20 2b 3d 20 73 74 72 |strFilte|r += str|
|000016a0| 54 68 65 46 69 65 6c 64 | 4e 61 6d 65 20 2b 20 22 |TheField|Name + "|
|000016b0| 20 22 20 2b 20 73 74 72 | 4c 6f 63 61 6c 4f 70 65 | " + str|LocalOpe|
|000016c0| 72 61 74 6f 72 20 2b 20 | 22 20 27 22 20 2b 20 73 |rator + |" '" + s|
|000016d0| 74 72 42 65 67 69 6e 57 | 69 6c 64 43 61 72 64 20 |trBeginW|ildCard |
|000016e0| 2b 20 74 68 69 73 56 61 | 6c 20 2b 20 73 74 72 45 |+ thisVa|l + strE|
|000016f0| 6e 64 57 69 6c 64 43 61 | 72 64 20 2b 20 22 27 22 |ndWildCa|rd + "'"|
|00001700| 0d 0a 09 69 66 20 28 69 | 20 3c 20 76 61 6c 75 65 |...if (i| < value|
|00001710| 73 2e 6c 65 6e 67 74 68 | 20 2d 31 29 0d 0a 09 7b |s.length| -1)...{|
|00001720| 0d 0a 09 09 73 74 72 46 | 69 6c 74 65 72 20 2b 3d |....strF|ilter +=|
|00001730| 20 22 20 4f 52 20 22 09 | 0d 0a 09 7d 0d 0a 09 0d | " OR ".|...}....|
|00001740| 0a 7d 0d 0a 0d 0a 73 74 | 72 46 69 6c 74 65 72 20 |.}....st|rFilter |
|00001750| 3d 20 41 64 64 46 69 6c | 74 65 72 57 72 61 70 28 |= AddFil|terWrap(|
|00001760| 73 74 72 46 69 6c 74 65 | 72 29 0d 0a 72 65 74 75 |strFilte|r)..retu|
|00001770| 72 6e 20 73 74 72 46 69 | 6c 74 65 72 0d 0a 0d 0a |rn strFi|lter....|
|00001780| 7d 0d 0a 41 83 5d a7 ea | 80 d2 11 80 51 00 10 4b |}..A.]..|....Q..K|
|00001790| d3 38 d1 01 80 02 00 00 | 00 11 55 52 4c 20 45 73 |.8......|..URL Es|
|000017a0| 63 61 70 65 20 53 70 61 | 63 65 73 ff 69 01 2f 2f |cape Spa|ces.i.//|
|000017b0| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 72 | This fu|nction r|
|000017c0| 65 70 6c 61 63 65 73 20 | 61 6c 6c 20 74 68 65 20 |eplaces |all the |
|000017d0| 73 70 61 63 65 73 20 69 | 6e 20 74 68 65 20 0d 0a |spaces i|n the ..|
|000017e0| 2f 2f 20 69 6e 20 73 74 | 72 69 6e 67 20 77 69 74 |// in st|ring wit|
|000017f0| 68 20 25 32 30 2e 20 20 | 46 6f 72 20 75 73 65 20 |h %20. |For use |
|00001800| 77 69 74 68 20 55 52 4c | 20 73 74 72 69 6e 67 73 |with URL| strings|
|00001810| 2e 0d 0a 66 75 6e 63 74 | 69 6f 6e 20 55 52 4c 45 |...funct|ion URLE|
|00001820| 73 63 61 70 65 53 70 61 | 63 65 73 28 73 74 72 49 |scapeSpa|ces(strI|
|00001830| 6e 29 0d 0a 7b 0d 0a 0d | 0a 09 76 61 72 20 61 20 |n)..{...|..var a |
|00001840| 3d 20 22 20 22 0d 0a 09 | 76 61 72 20 62 20 3d 20 |= " "...|var b = |
|00001850| 22 25 32 30 22 0d 0a 09 | 76 61 72 20 63 20 3d 20 |"%20"...|var c = |
|00001860| 73 74 72 49 6e 0d 0a 0d | 0a 09 76 61 72 20 69 20 |strIn...|..var i |
|00001870| 3d 20 63 2e 69 6e 64 65 | 78 4f 66 28 61 29 3b 0d |= c.inde|xOf(a);.|
|00001880| 0a 09 76 61 72 20 6c 20 | 3d 20 62 2e 6c 65 6e 67 |..var l |= b.leng|
|00001890| 74 68 3b 0d 0a 0d 0a 09 | 77 68 69 6c 65 20 28 69 |th;.....|while (i|
|000018a0| 20 21 3d 20 2d 31 29 09 | 7b 0d 0a 09 09 63 20 3d | != -1).|{....c =|
|000018b0| 20 63 2e 73 75 62 73 74 | 72 69 6e 67 28 30 2c 69 | c.subst|ring(0,i|
|000018c0| 29 20 2b 20 62 20 2b 20 | 63 2e 73 75 62 73 74 72 |) + b + |c.substr|
|000018d0| 69 6e 67 28 69 20 2b 20 | 61 2e 6c 65 6e 67 74 68 |ing(i + |a.length|
|000018e0| 2c 63 2e 6c 65 6e 67 74 | 68 29 3b 0d 0a 09 09 69 |,c.lengt|h);....i|
|000018f0| 20 3d 20 63 2e 69 6e 64 | 65 78 4f 66 28 61 2c 69 | = c.ind|exOf(a,i|
|00001900| 29 3b 0d 0a 09 7d 0d 0a | 09 72 65 74 75 72 6e 20 |);...}..|.return |
|00001910| 63 3b 0d 0a 0d 0a 7d e0 | 5a 9c 93 23 83 d2 11 80 |c;....}.|Z..#....|
|00001920| 52 00 10 4b d3 38 d1 0c | 00 ff ff 00 00 0a 00 78 |R..K.8..|.......x|
|00001930| 78 43 6f 6e 74 72 61 63 | 74 12 00 00 00 30 46 69 |xContrac|t....0Fi|
|00001940| 6c 74 65 72 20 5b 74 61 | 72 67 65 74 5d 20 77 69 |lter [ta|rget] wi|
|00001950| 74 68 20 72 65 6c 61 74 | 65 64 20 66 69 65 6c 64 |th relat|ed field|
|00001960| 20 66 72 6f 6d 20 5b 73 | 6f 75 72 63 65 5d 00 00 | from [s|ource]..|
|00001970| 00 00 00 02 00 ff ff 00 | 00 15 00 78 78 43 6f 6e |........|...xxCon|
|00001980| 74 72 61 63 74 50 61 72 | 74 69 63 69 70 61 6e 74 |tractPar|ticipant|
|00001990| 01 00 00 00 06 73 6f 75 | 72 63 65 02 00 ff ff 00 |.....sou|rce.....|
|000019a0| 00 15 00 78 78 43 6f 6e | 74 72 61 63 74 52 65 71 |...xxCon|tractReq|
|000019b0| 75 69 72 65 6d 65 6e 74 | 03 00 00 00 01 00 00 00 |uirement|........|
|000019c0| 0d 46 69 6c 74 65 72 28 | 77 68 65 72 65 29 08 80 |.Filter(|where)..|
|000019d0| 03 00 00 00 01 00 00 00 | 0a 4d 6f 76 65 4e 65 78 |........|.MoveNex|
|000019e0| 74 28 29 00 00 06 80 01 | 00 00 00 06 74 61 72 67 |t().....|....targ|
|000019f0| 65 74 04 00 08 80 03 00 | 00 00 00 00 00 00 08 53 |et......|.......S|
|00001a00| 65 72 76 65 72 28 29 08 | 80 03 00 00 00 01 00 00 |erver().|........|
|00001a10| 00 14 47 65 74 43 6f 6c | 75 6d 6e 56 61 6c 75 65 |..GetCol|umnValue|
|00001a20| 28 6e 61 6d 65 29 08 80 | 03 00 00 00 01 00 00 00 |(name)..|........|
|00001a30| 0a 4d 6f 76 65 4e 65 78 | 74 28 29 08 80 03 00 00 |.MoveNex|t().....|
|00001a40| 00 00 00 00 00 0c 42 65 | 66 6f 72 65 4f 70 65 6e |......Be|foreOpen|
|00001a50| 28 29 02 00 ff ff 00 00 | 10 00 78 78 43 6f 6e 74 |()......|..xxCont|
|00001a60| 72 61 63 74 41 63 74 69 | 6f 6e 04 00 00 00 0c 42 |ractActi|on.....B|
|00001a70| 65 66 6f 72 65 4f 70 65 | 6e 28 29 02 00 00 00 00 |eforeOpe|n().....|
|00001a80| 00 00 00 ff 1a 02 69 66 | 20 28 5b 73 6f 75 72 63 |......if| ([sourc|
|00001a90| 65 5d 29 20 0d 0a 7b 0d | 0a 20 20 20 20 69 66 20 |e]) ..{.|. if |
|00001aa0| 28 5b 73 6f 75 72 63 65 | 5d 2e 47 65 74 43 6f 6c |([source|].GetCol|
|00001ab0| 75 6d 6e 56 61 6c 75 65 | 28 5b 46 69 6c 74 65 72 |umnValue|([Filter|
|00001ac0| 42 79 5d 29 20 21 3d 20 | 22 75 6e 64 65 66 69 6e |By]) != |"undefin|
|00001ad0| 65 64 22 20 26 26 20 21 | 5b 73 6f 75 72 63 65 5d |ed" && !|[source]|
|00001ae0| 2e 49 73 45 4f 46 28 29 | 20 26 26 20 21 5b 73 6f |.IsEOF()| && ![so|
|00001af0| 75 72 63 65 5d 2e 49 73 | 42 4f 46 28 29 29 20 0d |urce].Is|BOF()) .|
|00001b00| 0a 20 20 20 20 7b 0d 0a | 20 20 20 20 20 20 20 20 |. {..| |
|00001b10| 76 61 72 20 77 68 65 72 | 65 20 3d 20 5b 46 69 6c |var wher|e = [Fil|
|00001b20| 74 65 72 43 6f 6c 75 6d | 6e 5d 20 2b 20 22 20 3d |terColum|n] + " =|
|00001b30| 20 27 22 20 2b 20 46 69 | 6c 74 65 72 53 75 70 70 | '" + Fi|lterSupp|
|00001b40| 6f 72 74 45 73 63 61 70 | 65 51 75 6f 74 65 73 28 |ortEscap|eQuotes(|
|00001b50| 5b 73 6f 75 72 63 65 5d | 2e 47 65 74 43 6f 6c 75 |[source]|.GetColu|
|00001b60| 6d 6e 56 61 6c 75 65 28 | 5b 46 69 6c 74 65 72 42 |mnValue(|[FilterB|
|00001b70| 79 5d 29 29 20 2b 20 22 | 27 22 0d 0a 20 20 20 20 |y])) + "|'".. |
|00001b80| 20 20 20 20 5b 74 61 72 | 67 65 74 5d 2e 41 63 74 | [tar|get].Act|
|00001b90| 69 6f 6e 20 3d 20 22 46 | 69 6c 74 65 72 28 5c 22 |ion = "F|ilter(\"|
|00001ba0| 22 20 2b 20 77 68 65 72 | 65 20 2b 20 22 5c 22 29 |" + wher|e + "\")|
|00001bb0| 22 0d 0a 20 20 20 20 7d | 0d 0a 7d 0d 0a 65 6c 73 |".. }|..}..els|
|00001bc0| 65 0d 0a 7b 0d 0a 20 20 | 20 20 52 65 73 70 6f 6e |e..{.. | Respon|
|00001bd0| 73 65 2e 57 72 69 74 65 | 28 22 3c 68 72 3e 3c 62 |se.Write|("<hr><b|
|00001be0| 3e 44 72 75 6d 62 65 61 | 74 20 49 6e 74 65 72 61 |>Drumbea|t Intera|
|00001bf0| 63 74 69 6f 6e 20 4d 65 | 73 73 61 67 65 3a 3c 2f |ction Me|ssage:</|
|00001c00| 62 3e 20 50 6c 65 61 73 | 65 20 6d 61 6b 65 20 73 |b> Pleas|e make s|
|00001c10| 75 72 65 20 74 68 61 74 | 20 74 68 65 20 52 65 63 |ure that| the Rec|
|00001c20| 6f 72 64 73 65 74 20 69 | 63 6f 6e 2c 20 5b 73 6f |ordset i|con, [so|
|00001c30| 75 72 63 65 5d 2c 20 69 | 73 20 74 6f 20 74 68 65 |urce], i|s to the|
|00001c40| 20 6c 65 66 74 20 6f 66 | 20 74 68 65 20 52 65 63 | left of| the Rec|
|00001c50| 6f 72 64 73 65 74 20 69 | 63 6f 6e 2c 20 5b 74 61 |ordset i|con, [ta|
|00001c60| 72 67 65 74 5d 2c 20 69 | 6e 20 74 68 65 20 62 61 |rget], i|n the ba|
|00001c70| 73 65 6d 65 6e 74 20 6f | 66 20 74 68 65 20 6c 61 |sement o|f the la|
|00001c80| 79 6f 75 74 2e 3c 68 72 | 3e 22 29 0d 0a 20 20 20 |yout.<hr|>").. |
|00001c90| 20 52 65 73 70 6f 6e 73 | 65 2e 45 6e 64 0d 0a 7d | Respons|e.End..}|
|00001ca0| 01 00 00 00 ff 1d 02 69 | 66 20 49 73 4f 62 6a 65 |.......i|f IsObje|
|00001cb0| 63 74 28 5b 73 6f 75 72 | 63 65 5d 29 20 74 68 65 |ct([sour|ce]) the|
|00001cc0| 6e 0d 0a 20 20 69 66 20 | 28 5b 73 6f 75 72 63 65 |n.. if |([source|
|00001cd0| 5d 2e 47 65 74 43 6f 6c | 75 6d 6e 56 61 6c 75 65 |].GetCol|umnValue|
|00001ce0| 28 5b 46 69 6c 74 65 72 | 42 79 5d 29 20 3c 3e 20 |([Filter|By]) <> |
|00001cf0| 22 75 6e 64 65 66 69 6e | 65 64 22 20 20 41 4e 44 |"undefin|ed" AND|
|00001d00| 20 4e 6f 74 20 5b 73 6f | 75 72 63 65 5d 2e 49 73 | Not [so|urce].Is|
|00001d10| 42 4f 46 28 29 20 41 4e | 44 20 4e 6f 74 20 5b 73 |BOF() AN|D Not [s|
|00001d20| 6f 75 72 63 65 5d 2e 49 | 73 45 4f 46 28 29 29 20 |ource].I|sEOF()) |
|00001d30| 74 68 65 6e 0d 0a 20 20 | 20 20 77 68 65 72 65 20 |then.. | where |
|00001d40| 3d 20 5b 46 69 6c 74 65 | 72 43 6f 6c 75 6d 6e 5d |= [Filte|rColumn]|
|00001d50| 20 26 20 22 20 3d 20 27 | 22 20 26 20 46 69 6c 74 | & " = '|" & Filt|
|00001d60| 65 72 53 75 70 70 6f 72 | 74 45 73 63 61 70 65 51 |erSuppor|tEscapeQ|
|00001d70| 75 6f 74 65 73 28 5b 73 | 6f 75 72 63 65 5d 2e 47 |uotes([s|ource].G|
|00001d80| 65 74 43 6f 6c 75 6d 6e | 56 61 6c 75 65 28 5b 46 |etColumn|Value([F|
|00001d90| 69 6c 74 65 72 42 79 5d | 29 29 20 26 20 22 27 22 |ilterBy]|)) & "'"|
|00001da0| 0d 0a 20 20 20 20 5b 74 | 61 72 67 65 74 5d 2e 41 |.. [t|arget].A|
|00001db0| 63 74 69 6f 6e 20 3d 20 | 22 46 69 6c 74 65 72 28 |ction = |"Filter(|
|00001dc0| 22 22 22 20 26 20 77 68 | 65 72 65 20 26 20 22 22 |""" & wh|ere & ""|
|00001dd0| 22 29 22 0d 0a 20 20 65 | 6e 64 20 69 66 0d 0a 65 |")".. e|nd if..e|
|00001de0| 6c 73 65 0d 0a 20 20 20 | 20 52 65 73 70 6f 6e 73 |lse.. | Respons|
|00001df0| 65 2e 57 72 69 74 65 28 | 22 3c 68 72 3e 3c 62 3e |e.Write(|"<hr><b>|
|00001e00| 44 72 75 6d 62 65 61 74 | 20 49 6e 74 65 72 61 63 |Drumbeat| Interac|
|00001e10| 74 69 6f 6e 20 4d 65 73 | 73 61 67 65 3a 3c 2f 62 |tion Mes|sage:</b|
|00001e20| 3e 20 50 6c 65 61 73 65 | 20 6d 61 6b 65 20 73 75 |> Please| make su|
|00001e30| 72 65 20 74 68 61 74 20 | 74 68 65 20 52 65 63 6f |re that |the Reco|
|00001e40| 72 64 73 65 74 20 69 63 | 6f 6e 2c 20 5b 73 6f 75 |rdset ic|on, [sou|
|00001e50| 72 63 65 5d 2c 20 69 73 | 20 74 6f 20 74 68 65 20 |rce], is| to the |
|00001e60| 6c 65 66 74 20 6f 66 20 | 74 68 65 20 52 65 63 6f |left of |the Reco|
|00001e70| 72 64 73 65 74 20 69 63 | 6f 6e 2c 20 5b 74 61 72 |rdset ic|on, [tar|
|00001e80| 67 65 74 5d 2c 20 69 6e | 20 74 68 65 20 62 61 73 |get], in| the bas|
|00001e90| 65 6d 65 6e 74 20 6f 66 | 20 74 68 65 20 6c 61 79 |ement of| the lay|
|00001ea0| 6f 75 74 2e 3c 68 72 3e | 22 29 0d 0a 20 20 20 20 |out.<hr>|").. |
|00001eb0| 52 65 73 70 6f 6e 73 65 | 2e 45 6e 64 0d 0a 65 6e |Response|.End..en|
|00001ec0| 64 20 69 66 10 80 04 00 | 00 00 08 53 65 72 76 65 |d if....|...Serve|
|00001ed0| 72 28 29 02 00 00 00 00 | 00 00 00 00 01 00 00 00 |r().....|........|
|00001ee0| 00 02 00 ff ff 00 00 0d | 00 78 78 53 63 72 69 70 |........|.xxScrip|
|00001ef0| 74 50 61 72 61 6d 05 00 | 00 00 08 46 69 6c 74 65 |tParam..|...Filte|
|00001f00| 72 42 79 04 00 00 00 08 | 00 00 00 00 00 00 00 01 |rBy.....|........|
|00001f10| 00 00 00 06 73 6f 75 72 | 63 65 00 00 00 00 13 80 |....sour|ce......|
|00001f20| 05 00 00 00 0c 46 69 6c | 74 65 72 43 6f 6c 75 6d |.....Fil|terColum|
|00001f30| 6e 04 00 00 00 08 00 00 | 00 00 00 00 00 01 00 00 |n.......|........|
|00001f40| 00 06 74 61 72 67 65 74 | 00 00 00 00 0f 44 61 74 |..target|.....Dat|
|00001f50| 61 62 61 73 65 20 46 69 | 6c 74 65 72 01 00 41 83 |abase Fi|lter..A.|
|00001f60| 5d a7 ea 80 d2 11 80 51 | 00 10 4b d3 38 d1 00 00 |]......Q|..K.8...|
|00001f70| 00 00 04 00 00 00 01 00 | 00 00 00 00 8e 7a 55 51 |........|.....zUQ|
|00001f80| c7 8f d2 11 80 5a 00 10 | 4b d3 38 d1 01 00 00 00 |.....Z..|K.8.....|
|00001f90| 24 33 37 37 41 43 34 33 | 30 2d 36 32 31 31 2d 31 |$377AC43|0-6211-1|
|00001fa0| 31 44 32 2d 38 31 31 37 | 2d 30 30 36 30 30 38 43 |1D2-8117|-006008C|
|00001fb0| 38 36 43 32 35 03 33 2e | 30 ff dc 02 56 31 30 5f |86C25.3.|0...V10_|
|00001fc0| 33 30 0d 0a 44 65 73 63 | 72 69 70 74 69 6f 6e 3a |30..Desc|ription:|
|00001fd0| 0d 0a 54 68 69 73 20 69 | 6e 74 65 72 61 63 74 69 |..This i|nteracti|
|00001fe0| 6f 6e 20 65 6e 61 62 6c | 65 73 20 79 6f 75 20 74 |on enabl|es you t|
|00001ff0| 6f 20 66 69 6c 74 65 72 | 20 6f 6e 65 20 52 65 63 |o filter| one Rec|
|00002000| 6f 72 64 73 65 74 20 62 | 61 73 65 64 20 6f 6e 20 |ordset b|ased on |
|00002010| 74 68 65 20 76 61 6c 75 | 65 20 6f 66 20 61 20 63 |the valu|e of a c|
|00002020| 65 72 74 61 69 6e 20 66 | 69 65 6c 64 20 6f 66 20 |ertain f|ield of |
|00002030| 61 6e 6f 74 68 65 72 20 | 52 65 63 6f 72 64 73 65 |another |Recordse|
|00002040| 74 20 6f 6e 20 74 68 65 | 20 73 61 6d 65 20 70 61 |t on the| same pa|
|00002050| 67 65 2e 0d 0a 0d 0a 50 | 61 72 61 6d 65 74 65 72 |ge.....P|arameter|
|00002060| 73 3a 0d 0a 46 69 6c 74 | 65 72 42 79 20 2d 20 74 |s:..Filt|erBy - t|
|00002070| 68 65 20 66 69 65 6c 64 | 20 69 6e 20 74 68 65 20 |he field| in the |
|00002080| 5b 73 6f 75 72 63 65 5d | 20 52 65 63 6f 72 64 73 |[source]| Records|
|00002090| 65 74 20 74 68 61 74 20 | 68 61 73 20 61 20 66 69 |et that |has a fi|
|000020a0| 65 6c 64 20 72 65 6c 61 | 74 65 64 20 74 6f 20 61 |eld rela|ted to a|
|000020b0| 20 66 69 65 6c 64 20 69 | 6e 20 5b 74 61 72 67 65 | field i|n [targe|
|000020c0| 74 5d 0d 0a 46 69 6c 74 | 65 72 43 6f 6c 75 6d 6e |t]..Filt|erColumn|
|000020d0| 20 2d 20 74 68 65 20 66 | 69 65 6c 64 20 69 6e 20 | - the f|ield in |
|000020e0| 74 68 65 20 5b 74 61 72 | 67 65 74 5d 20 52 65 63 |the [tar|get] Rec|
|000020f0| 6f 72 64 73 65 74 20 74 | 68 61 74 20 68 61 73 20 |ordset t|hat has |
|00002100| 61 20 66 69 65 6c 64 20 | 72 65 6c 61 74 65 64 20 |a field |related |
|00002110| 74 6f 20 61 20 66 69 65 | 6c 64 20 69 6e 20 5b 73 |to a fie|ld in [s|
|00002120| 6f 75 72 63 65 5d 0d 0a | 0d 0a 54 79 70 69 63 61 |ource]..|..Typica|
|00002130| 6c 20 50 61 72 74 69 63 | 69 70 61 6e 74 73 3a 0d |l Partic|ipants:.|
|00002140| 0a 5b 74 61 72 67 65 74 | 5d 20 2d 20 74 68 65 20 |.[target|] - the |
|00002150| 52 65 63 6f 72 64 73 65 | 74 20 74 68 61 74 20 77 |Recordse|t that w|
|00002160| 69 6c 6c 20 62 65 20 66 | 69 6c 74 65 72 65 64 20 |ill be f|iltered |
|00002170| 64 65 70 65 6e 64 69 6e | 67 20 6f 6e 20 74 68 65 |dependin|g on the|
|00002180| 20 76 61 6c 75 65 20 6f | 66 20 61 20 72 65 6c 61 | value o|f a rela|
|00002190| 74 65 64 20 66 69 65 6c | 64 20 69 6e 20 5b 74 61 |ted fiel|d in [ta|
|000021a0| 72 67 65 74 5d 0d 0a 5b | 73 6f 75 72 63 65 5d 20 |rget]..[|source] |
|000021b0| 2d 20 74 68 65 20 52 65 | 63 6f 72 64 73 65 74 20 |- the Re|cordset |
|000021c0| 74 68 61 74 20 63 6f 6e | 74 61 69 6e 73 20 61 20 |that con|tains a |
|000021d0| 66 69 65 6c 64 20 74 68 | 61 74 20 69 73 20 75 73 |field th|at is us|
|000021e0| 65 64 20 74 6f 20 66 69 | 6c 74 65 72 20 5b 73 6f |ed to fi|lter [so|
|000021f0| 75 72 63 65 5d 0d 0a 0d | 0a 4e 6f 74 65 3a 20 74 |urce]...|.Note: t|
|00002200| 68 65 20 5b 73 6f 75 72 | 63 65 5d 20 6d 75 73 74 |he [sour|ce] must|
|00002210| 20 62 65 20 74 6f 20 74 | 68 65 20 6c 65 66 74 20 | be to t|he left |
|00002220| 6f 66 20 74 68 65 20 5b | 74 61 72 67 65 74 5d 20 |of the [|target] |
|00002230| 69 6e 20 74 68 65 20 62 | 61 73 65 6d 65 6e 74 2e |in the b|asement.|
|00002240| 0d 0a 0d 0a 53 65 65 20 | 44 61 74 61 62 61 73 65 |....See |Database|
|00002250| 46 69 6c 74 65 72 56 31 | 30 5f 33 30 2e 64 6f 63 |FilterV1|0_30.doc|
|00002260| 20 66 6f 72 20 67 65 6e | 65 72 61 6c 20 69 6e 66 | for gen|eral inf|
|00002270| 6f 72 6d 61 74 69 6f 6e | 20 6f 6e 20 44 61 74 61 |ormation| on Data|
|00002280| 62 61 73 65 20 46 69 6c | 74 65 72 20 63 6f 6e 74 |base Fil|ter cont|
|00002290| 72 61 63 74 73 2e 20 20 | 04 80 12 00 00 00 49 41 |racts. |......IA|
|000022a0| 64 64 20 5b 76 61 6c 75 | 65 20 69 6e 5d 20 65 64 |dd [valu|e in] ed|
|000022b0| 69 74 20 62 6f 78 20 74 | 6f 20 66 69 6c 74 65 72 |it box t|o filter|
|000022c0| 20 6f 66 20 5b 52 65 63 | 6f 72 64 73 65 74 5d 20 | of [Rec|ordset] |
|000022d0| 77 68 65 6e 20 5b 42 75 | 74 74 6f 6e 5d 20 69 73 |when [Bu|tton] is|
|000022e0| 20 63 6c 69 63 6b 65 64 | 00 00 00 00 00 03 00 06 | clicked|........|
|000022f0| 80 01 00 00 00 08 56 61 | 6c 75 65 20 49 6e 01 00 |......Va|lue In..|
|00002300| 08 80 03 00 00 00 01 00 | 00 00 09 67 65 74 54 65 |........|...getTe|
|00002310| 78 74 28 29 00 00 06 80 | 01 00 00 00 09 52 65 63 |xt()....|.....Rec|
|00002320| 6f 72 64 73 65 74 02 00 | 08 80 03 00 00 00 00 00 |ordset..|........|
|00002330| 00 00 0c 42 65 66 6f 72 | 65 4f 70 65 6e 28 29 08 |...Befor|eOpen().|
|00002340| 80 03 00 00 00 01 00 00 | 00 0a 4d 6f 76 65 4e 65 |........|..MoveNe|
|00002350| 78 74 28 29 01 00 10 80 | 04 00 00 00 0c 42 65 66 |xt()....|.....Bef|
|00002360| 6f 72 65 4f 70 65 6e 28 | 29 02 00 00 00 00 00 00 |oreOpen(|).......|
|00002370| 00 a4 69 66 20 28 52 65 | 71 75 65 73 74 2e 46 6f |..if (Re|quest.Fo|
|00002380| 72 6d 2e 4b 65 79 28 22 | 5b 42 75 74 74 6f 6e 5d |rm.Key("|[Button]|
|00002390| 22 29 20 21 3d 20 22 22 | 29 0d 0a 7b 0d 0a 20 20 |") != ""|)..{.. |
|000023a0| 20 20 41 64 64 54 6f 46 | 69 6c 74 65 72 28 5b 52 | AddToF|ilter([R|
|000023b0| 65 63 6f 72 64 73 65 74 | 5d 2c 20 22 5b 56 61 6c |ecordset|], "[Val|
|000023c0| 75 65 20 49 6e 5d 22 2c | 20 5b 52 65 63 6f 72 64 |ue In]",| [Record|
|000023d0| 73 65 74 20 46 69 65 6c | 64 5d 2c 20 5b 4f 70 65 |set Fiel|d], [Ope|
|000023e0| 72 61 74 6f 72 5d 2c 20 | 5b 43 6f 6e 6e 65 63 74 |rator], |[Connect|
|000023f0| 6f 72 5d 2c 20 22 45 64 | 69 74 42 6f 78 22 2c 20 |or], "Ed|itBox", |
|00002400| 5b 43 6c 61 75 73 65 20 | 53 65 70 61 72 61 74 6f |[Clause |Separato|
|00002410| 72 5d 29 0d 0a 7d 01 00 | 00 00 a8 69 66 20 52 65 |r])..}..|...if Re|
|00002420| 71 75 65 73 74 2e 46 6f | 72 6d 2e 4b 65 79 28 22 |quest.Fo|rm.Key("|
|00002430| 5b 42 75 74 74 6f 6e 5d | 22 29 20 3c 3e 20 22 22 |[Button]|") <> ""|
|00002440| 20 74 68 65 6e 0d 0a 20 | 20 20 20 41 64 64 54 6f | then.. | AddTo|
|00002450| 46 69 6c 74 65 72 20 5b | 52 65 63 6f 72 64 73 65 |Filter [|Recordse|
|00002460| 74 5d 2c 20 22 5b 56 61 | 6c 75 65 20 49 6e 5d 22 |t], "[Va|lue In]"|
|00002470| 2c 20 5b 52 65 63 6f 72 | 64 73 65 74 20 46 69 65 |, [Recor|dset Fie|
|00002480| 6c 64 5d 2c 20 5b 4f 70 | 65 72 61 74 6f 72 5d 2c |ld], [Op|erator],|
|00002490| 20 5b 43 6f 6e 6e 65 63 | 74 6f 72 5d 2c 20 22 45 | [Connec|tor], "E|
|000024a0| 64 69 74 42 6f 78 22 2c | 20 5b 43 6c 61 75 73 65 |ditBox",| [Clause|
|000024b0| 20 53 65 70 61 72 61 74 | 6f 72 5d 0d 0a 65 6e 64 | Separat|or]..end|
|000024c0| 20 69 66 06 80 01 00 00 | 00 06 42 75 74 74 6f 6e | if.....|..Button|
|000024d0| 01 00 08 80 03 00 00 00 | 00 00 00 00 07 6f 6e 43 |........|.....onC|
|000024e0| 6c 69 63 6b 00 00 04 00 | 13 80 05 00 00 00 08 4f |lick....|.......O|
|000024f0| 70 65 72 61 74 6f 72 04 | 00 00 00 08 00 04 00 00 |perator.|........|
|00002500| 00 3c 00 3d 00 08 00 01 | 3c 02 3c 3d 01 3d 01 3e |.<.=....|<.<=.=.>|
|00002510| 02 3e 3d 0b 42 65 67 69 | 6e 73 20 77 69 74 68 08 |.>=.Begi|ns with.|
|00002520| 49 6e 63 6c 75 64 65 73 | 0c 4e 6f 74 20 65 71 75 |Includes|.Not equ|
|00002530| 61 6c 20 74 6f 00 00 00 | 00 00 00 00 00 00 13 80 |al to...|........|
|00002540| 05 00 00 00 09 43 6f 6e | 6e 65 63 74 6f 72 04 00 |.....Con|nector..|
|00002550| 00 00 08 00 02 00 00 00 | 20 00 03 00 01 20 03 41 |........| .... .A|
|00002560| 4e 44 02 4f 52 00 00 00 | 00 00 00 00 00 00 13 80 |ND.OR...|........|
|00002570| 05 00 00 00 0f 52 65 63 | 6f 72 64 73 65 74 20 46 |.....Rec|ordset F|
|00002580| 69 65 6c 64 04 00 00 00 | 08 00 00 00 00 00 00 00 |ield....|........|
|00002590| 01 00 00 00 09 52 65 63 | 6f 72 64 73 65 74 00 00 |.....Rec|ordset..|
|000025a0| 00 00 13 80 05 00 00 00 | 10 43 6c 61 75 73 65 20 |........|.Clause |
|000025b0| 53 65 70 61 72 61 74 6f | 72 04 00 00 00 08 00 02 |Separato|r.......|
|000025c0| 00 00 00 20 00 03 00 01 | 20 01 28 01 29 00 00 00 |... ....| .(.)...|
|000025d0| 00 00 00 00 00 00 0f 44 | 61 74 61 62 61 73 65 20 |.......D|atabase |
|000025e0| 46 69 6c 74 65 72 01 00 | 41 83 5d a7 ea 80 d2 11 |Filter..|A.].....|
|000025f0| 80 51 00 10 4b d3 38 d1 | 00 00 00 00 04 00 00 00 |.Q..K.8.|........|
|00002600| 01 00 00 00 01 00 10 80 | 04 00 00 00 06 53 65 72 |........|.....Ser|
|00002610| 76 65 72 01 00 00 00 00 | 00 00 00 00 3b 8f b4 dc |ver.....|....;...|
|00002620| d4 80 d2 11 80 51 00 10 | 4b d3 38 d1 01 00 00 00 |.....Q..|K.8.....|
|00002630| 24 33 37 37 41 43 34 33 | 30 2d 36 32 31 31 2d 31 |$377AC43|0-6211-1|
|00002640| 31 44 32 2d 38 31 31 37 | 2d 30 30 36 30 30 38 43 |1D2-8117|-006008C|
|00002650| 38 36 43 32 35 03 33 2e | 30 ff 5c 04 56 31 30 5f |86C25.3.|0.\.V10_|
|00002660| 33 30 0d 0a 44 65 73 63 | 72 69 70 74 69 6f 6e 3a |30..Desc|ription:|
|00002670| 0d 0a 54 68 69 73 20 69 | 6e 74 65 72 61 63 74 69 |..This i|nteracti|
|00002680| 6f 6e 20 69 73 20 75 73 | 65 64 20 74 6f 20 62 75 |on is us|ed to bu|
|00002690| 69 6c 64 20 61 20 66 69 | 6c 74 65 72 20 6f 6e 20 |ild a fi|lter on |
|000026a0| 61 20 52 65 63 6f 72 64 | 73 65 74 2e 20 20 54 68 |a Record|set. Th|
|000026b0| 69 73 20 69 73 20 61 20 | 53 45 52 56 45 52 20 53 |is is a |SERVER S|
|000026c0| 49 44 45 20 63 6f 6e 74 | 72 61 63 74 20 77 68 69 |IDE cont|ract whi|
|000026d0| 63 68 20 6d 65 61 6e 73 | 20 74 68 61 74 20 75 73 |ch means| that us|
|000026e0| 65 72 73 20 77 69 74 68 | 20 62 72 6f 77 73 65 72 |ers with| browser|
|000026f0| 73 20 74 68 61 74 20 64 | 6f 20 6e 6f 74 20 73 75 |s that d|o not su|
|00002700| 70 70 6f 72 74 20 4a 61 | 76 61 53 63 72 69 70 74 |pport Ja|vaScript|
|00002710| 20 63 61 6e 20 73 74 69 | 6c 6c 20 62 72 6f 77 73 | can sti|ll brows|
|00002720| 65 20 74 68 69 73 20 70 | 61 67 65 2e 0d 0a 0d 0a |e this p|age.....|
|00002730| 50 61 72 61 6d 65 74 65 | 72 73 3a 0d 0a 43 6c 61 |Paramete|rs:..Cla|
|00002740| 75 73 65 20 53 65 70 61 | 72 61 74 6f 72 20 2d 20 |use Sepa|rator - |
|00002750| 65 69 74 68 65 72 20 22 | 28 22 2c 20 22 29 22 2c |either "|(", ")",|
|00002760| 20 6f 72 20 22 20 22 0d | 0a 43 6f 6e 6e 65 63 74 | or " ".|.Connect|
|00002770| 6f 72 20 2d 20 64 65 74 | 65 72 6d 69 6e 65 73 20 |or - det|ermines |
|00002780| 68 6f 77 20 74 68 65 20 | 65 64 69 74 20 62 6f 78 |how the |edit box|
|00002790| 20 77 69 6c 6c 20 62 65 | 20 63 6f 6e 6e 65 63 74 | will be| connect|
|000027a0| 65 64 20 74 6f 20 74 68 | 65 20 65 78 69 73 74 69 |ed to th|e existi|
|000027b0| 6e 67 20 66 69 6c 74 65 | 72 2c 20 65 69 74 68 65 |ng filte|r, eithe|
|000027c0| 72 20 41 4e 44 20 6f 72 | 20 4f 52 2e 20 4c 45 41 |r AND or| OR. LEA|
|000027d0| 56 45 20 42 4c 41 4e 4b | 20 69 66 20 74 68 69 73 |VE BLANK| if this|
|000027e0| 20 69 73 20 74 68 65 20 | 66 69 72 73 74 20 66 6f | is the |first fo|
|000027f0| 72 6d 20 65 6c 65 6d 65 | 6e 74 20 69 6e 20 74 68 |rm eleme|nt in th|
|00002800| 65 20 66 69 6c 74 65 72 | 2e 0d 0a 4f 70 65 72 61 |e filter|...Opera|
|00002810| 74 6f 72 20 2d 20 74 68 | 65 20 77 61 79 20 74 68 |tor - th|e way th|
|00002820| 65 20 64 61 74 61 20 74 | 68 65 20 75 73 65 72 20 |e data t|he user |
|00002830| 65 6e 74 65 72 73 20 69 | 6e 20 74 68 65 20 65 64 |enters i|n the ed|
|00002840| 69 74 20 62 6f 78 20 69 | 73 20 74 6f 20 62 65 20 |it box i|s to be |
|00002850| 63 6f 6d 70 61 72 65 64 | 20 74 6f 20 74 68 65 20 |compared| to the |
|00002860| 64 61 74 61 20 69 6e 20 | 74 68 61 74 20 67 69 76 |data in |that giv|
|00002870| 65 6e 20 66 69 65 6c 64 | 20 6f 66 20 74 68 65 20 |en field| of the |
|00002880| 52 65 63 6f 72 64 73 65 | 74 2e 20 47 72 65 61 74 |Recordse|t. Great|
|00002890| 65 72 20 74 68 61 6e 2c | 20 6c 65 73 73 20 74 68 |er than,| less th|
|000028a0| 61 6e 2c 20 65 71 75 61 | 6c 20 74 6f 2c 20 65 74 |an, equa|l to, et|
|000028b0| 63 2e 0d 0a 52 65 63 6f | 72 64 73 65 74 20 46 69 |c...Reco|rdset Fi|
|000028c0| 65 6c 64 20 2d 20 74 68 | 65 20 66 69 65 6c 64 20 |eld - th|e field |
|000028d0| 6f 6e 20 74 68 65 20 52 | 65 63 6f 72 64 73 65 74 |on the R|ecordset|
|000028e0| 20 74 68 61 74 20 69 73 | 20 74 6f 20 62 65 20 75 | that is| to be u|
|000028f0| 73 65 64 20 74 6f 20 63 | 6f 6d 70 61 72 65 20 74 |sed to c|ompare t|
|00002900| 6f 20 74 68 65 20 76 61 | 6c 75 65 20 69 6e 20 74 |o the va|lue in t|
|00002910| 68 65 20 65 64 69 74 20 | 62 6f 78 2e 0d 0a 0d 0a |he edit |box.....|
|00002920| 54 79 70 69 63 61 6c 20 | 50 61 72 74 69 63 69 70 |Typical |Particip|
|00002930| 61 6e 74 73 3a 0d 0a 5b | 52 65 63 6f 72 64 73 65 |ants:..[|Recordse|
|00002940| 74 5d 20 2d 20 61 20 52 | 65 63 6f 72 64 73 65 74 |t] - a R|ecordset|
|00002950| 0d 0a 5b 56 61 6c 75 65 | 20 49 6e 5d 20 2d 20 61 |..[Value| In] - a|
|00002960| 6e 20 65 64 69 74 20 62 | 6f 78 0d 0a 5b 42 75 74 |n edit b|ox..[But|
|00002970| 74 6f 6e 5d 20 2d 20 61 | 6e 20 69 6d 61 67 65 20 |ton] - a|n image |
|00002980| 6f 72 20 66 6f 72 6d 20 | 62 75 74 74 6f 6e 0d 0a |or form |button..|
|00002990| 0d 0a 4e 6f 74 65 3a 20 | 41 6e 79 20 65 64 69 74 |..Note: |Any edit|
|000029a0| 20 62 6f 78 20 74 68 61 | 74 20 69 73 20 6c 65 66 | box tha|t is lef|
|000029b0| 74 20 62 6c 61 6e 6b 20 | 62 79 20 74 68 65 20 75 |t blank |by the u|
|000029c0| 73 65 72 20 77 69 6c 6c | 20 6e 6f 74 20 62 65 20 |ser will| not be |
|000029d0| 61 64 64 65 64 20 74 6f | 20 74 68 65 20 66 69 6c |added to| the fil|
|000029e0| 74 65 72 2e 0d 0a 0d 0a | 4e 6f 74 65 3a 20 54 68 |ter.....|Note: Th|
|000029f0| 69 73 20 63 6f 6e 74 72 | 61 63 74 20 69 73 20 74 |is contr|act is t|
|00002a00| 6f 20 62 65 20 75 73 65 | 64 20 69 6e 20 63 6f 6e |o be use|d in con|
|00002a10| 6a 75 6e 63 74 69 6f 6e | 20 77 69 74 68 20 74 68 |junction| with th|
|00002a20| 65 20 63 6f 6e 74 72 61 | 63 74 20 22 46 69 6c 74 |e contra|ct "Filt|
|00002a30| 65 72 20 5b 52 65 63 6f | 72 64 73 65 74 5d 20 77 |er [Reco|rdset] w|
|00002a40| 68 65 6e 20 5b 73 6f 75 | 72 63 65 5d 20 62 75 74 |hen [sou|rce] but|
|00002a50| 74 6f 6e 20 69 73 20 63 | 6c 69 63 6b 65 64 22 0d |ton is c|licked".|
|00002a60| 0a 0d 0a 53 65 65 20 44 | 61 74 61 62 61 73 65 46 |...See D|atabaseF|
|00002a70| 69 6c 74 65 72 56 31 30 | 5f 33 30 2e 64 6f 63 20 |ilterV10|_30.doc |
|00002a80| 66 6f 72 20 67 65 6e 65 | 72 61 6c 20 69 6e 66 6f |for gene|ral info|
|00002a90| 72 6d 61 74 69 6f 6e 20 | 6f 6e 20 44 61 74 61 62 |rmation |on Datab|
|00002aa0| 61 73 65 20 46 69 6c 74 | 65 72 20 63 6f 6e 74 72 |ase Filt|er contr|
|00002ab0| 61 63 74 73 2e 20 0d 0a | 04 80 12 00 00 00 54 41 |acts. ..|......TA|
|00002ac0| 64 64 20 5b 76 61 6c 75 | 65 20 69 6e 5d 20 64 72 |dd [valu|e in] dr|
|00002ad0| 6f 70 64 6f 77 6e 20 6c | 69 73 74 20 76 61 6c 75 |opdown l|ist valu|
|00002ae0| 65 20 74 6f 20 66 69 6c | 74 65 72 20 6f 66 20 5b |e to fil|ter of [|
|00002af0| 52 65 63 6f 72 64 73 65 | 74 5d 20 77 68 65 6e 20 |Recordse|t] when |
|00002b00| 5b 42 75 74 74 6f 6e 5d | 20 69 73 20 63 6c 69 63 |[Button]| is clic|
|00002b10| 6b 65 64 00 00 00 00 00 | 03 00 06 80 01 00 00 00 |ked.....|........|
|00002b20| 08 56 61 6c 75 65 20 49 | 6e 01 00 08 80 03 00 00 |.Value I|n.......|
|00002b30| 00 01 00 00 00 12 67 65 | 74 53 65 6c 65 63 74 65 |......ge|tSelecte|
|00002b40| 64 56 61 6c 75 65 28 29 | 00 00 06 80 01 00 00 00 |dValue()|........|
|00002b50| 09 52 65 63 6f 72 64 73 | 65 74 02 00 08 80 03 00 |.Records|et......|
|00002b60| 00 00 00 00 00 00 0c 42 | 65 66 6f 72 65 4f 70 65 |.......B|eforeOpe|
|00002b70| 6e 28 29 08 80 03 00 00 | 00 01 00 00 00 0a 4d 6f |n().....|......Mo|
|00002b80| 76 65 4e 65 78 74 28 29 | 01 00 10 80 04 00 00 00 |veNext()|........|
|00002b90| 0c 42 65 66 6f 72 65 4f | 70 65 6e 28 29 02 00 00 |.BeforeO|pen()...|
|00002ba0| 00 00 00 00 00 a4 69 66 | 20 28 52 65 71 75 65 73 |......if| (Reques|
|00002bb0| 74 2e 46 6f 72 6d 2e 4b | 65 79 28 22 5b 42 75 74 |t.Form.K|ey("[But|
|00002bc0| 74 6f 6e 5d 22 29 20 21 | 3d 20 22 22 29 0d 0a 7b |ton]") !|= "")..{|
|00002bd0| 0d 0a 20 20 20 20 41 64 | 64 54 6f 46 69 6c 74 65 |.. Ad|dToFilte|
|00002be0| 72 28 5b 52 65 63 6f 72 | 64 73 65 74 5d 2c 20 22 |r([Recor|dset], "|
|00002bf0| 5b 56 61 6c 75 65 20 49 | 6e 5d 22 2c 20 5b 52 65 |[Value I|n]", [Re|
|00002c00| 63 6f 72 64 73 65 74 20 | 46 69 65 6c 64 5d 2c 20 |cordset |Field], |
|00002c10| 5b 4f 70 65 72 61 74 6f | 72 5d 2c 20 5b 43 6f 6e |[Operato|r], [Con|
|00002c20| 6e 65 63 74 6f 72 5d 2c | 20 22 4c 69 73 74 42 6f |nector],| "ListBo|
|00002c30| 78 22 2c 20 5b 43 6c 61 | 75 73 65 20 53 65 70 61 |x", [Cla|use Sepa|
|00002c40| 72 61 74 6f 72 5d 29 0d | 0a 7d 01 00 00 00 a8 69 |rator]).|.}.....i|
|00002c50| 66 20 52 65 71 75 65 73 | 74 2e 46 6f 72 6d 2e 4b |f Reques|t.Form.K|
|00002c60| 65 79 28 22 5b 42 75 74 | 74 6f 6e 5d 22 29 20 3c |ey("[But|ton]") <|
|00002c70| 3e 20 22 22 20 74 68 65 | 6e 0d 0a 20 20 20 20 41 |> "" the|n.. A|
|00002c80| 64 64 54 6f 46 69 6c 74 | 65 72 20 5b 52 65 63 6f |ddToFilt|er [Reco|
|00002c90| 72 64 73 65 74 5d 2c 20 | 22 5b 56 61 6c 75 65 20 |rdset], |"[Value |
|00002ca0| 49 6e 5d 22 2c 20 5b 52 | 65 63 6f 72 64 73 65 74 |In]", [R|ecordset|
|00002cb0| 20 46 69 65 6c 64 5d 2c | 20 5b 4f 70 65 72 61 74 | Field],| [Operat|
|00002cc0| 6f 72 5d 2c 20 5b 43 6f | 6e 6e 65 63 74 6f 72 5d |or], [Co|nnector]|
|00002cd0| 2c 20 22 4c 69 73 74 42 | 6f 78 22 2c 20 5b 43 6c |, "ListB|ox", [Cl|
|00002ce0| 61 75 73 65 20 53 65 70 | 61 72 61 74 6f 72 5d 0d |ause Sep|arator].|
|00002cf0| 0a 65 6e 64 20 69 66 06 | 80 01 00 00 00 06 42 75 |.end if.|......Bu|
|00002d00| 74 74 6f 6e 01 00 08 80 | 03 00 00 00 00 00 00 00 |tton....|........|
|00002d10| 07 6f 6e 43 6c 69 63 6b | 00 00 04 00 13 80 05 00 |.onClick|........|
|00002d20| 00 00 08 4f 70 65 72 61 | 74 6f 72 04 00 00 00 08 |...Opera|tor.....|
|00002d30| 00 04 00 00 00 3c 00 3d | 00 08 00 01 3c 02 3c 3d |.....<.=|....<.<=|
|00002d40| 01 3d 01 3e 02 3e 3d 0b | 42 65 67 69 6e 73 20 77 |.=.>.>=.|Begins w|
|00002d50| 69 74 68 08 49 6e 63 6c | 75 64 65 73 0c 4e 6f 74 |ith.Incl|udes.Not|
|00002d60| 20 65 71 75 61 6c 20 74 | 6f 00 00 00 00 00 00 00 | equal t|o.......|
|00002d70| 00 00 13 80 05 00 00 00 | 09 43 6f 6e 6e 65 63 74 |........|.Connect|
|00002d80| 6f 72 04 00 00 00 08 00 | 02 00 00 00 20 00 03 00 |or......|.... ...|
|00002d90| 01 20 03 41 4e 44 02 4f | 52 00 00 00 00 00 00 00 |. .AND.O|R.......|
|00002da0| 00 00 13 80 05 00 00 00 | 0f 52 65 63 6f 72 64 73 |........|.Records|
|00002db0| 65 74 20 46 69 65 6c 64 | 04 00 00 00 08 00 00 00 |et Field|........|
|00002dc0| 00 00 00 00 01 00 00 00 | 09 52 65 63 6f 72 64 73 |........|.Records|
|00002dd0| 65 74 00 00 00 00 13 80 | 05 00 00 00 10 43 6c 61 |et......|.....Cla|
|00002de0| 75 73 65 20 53 65 70 61 | 72 61 74 6f 72 04 00 00 |use Sepa|rator...|
|00002df0| 00 08 00 02 00 00 00 20 | 00 03 00 01 20 01 28 01 |....... |.... .(.|
|00002e00| 29 00 00 00 00 00 00 00 | 00 00 0f 44 61 74 61 62 |).......|...Datab|
|00002e10| 61 73 65 20 46 69 6c 74 | 65 72 01 00 41 83 5d a7 |ase Filt|er..A.].|
|00002e20| ea 80 d2 11 80 51 00 10 | 4b d3 38 d1 00 00 00 00 |.....Q..|K.8.....|
|00002e30| 04 00 00 00 01 00 00 00 | 01 00 10 80 04 00 00 00 |........|........|
|00002e40| 06 53 65 72 76 65 72 01 | 00 00 00 00 00 00 00 00 |.Server.|........|
|00002e50| 4f c5 ff 19 e8 80 d2 11 | 80 51 00 10 4b d3 38 d1 |O.......|.Q..K.8.|
|00002e60| 01 00 00 00 24 33 37 37 | 41 43 34 33 30 2d 36 32 |....$377|AC430-62|
|00002e70| 31 31 2d 31 31 44 32 2d | 38 31 31 37 2d 30 30 36 |11-11D2-|8117-006|
|00002e80| 30 30 38 43 38 36 43 32 | 35 03 33 2e 30 ff b3 04 |008C86C2|5.3.0...|
|00002e90| 56 31 30 5f 33 30 0d 0a | 44 65 73 63 72 69 70 74 |V10_30..|Descript|
|00002ea0| 69 6f 6e 3a 0d 0a 54 68 | 69 73 20 69 6e 74 65 72 |ion:..Th|is inter|
|00002eb0| 61 63 74 69 6f 6e 20 69 | 73 20 75 73 65 64 20 74 |action i|s used t|
|00002ec0| 6f 20 62 75 69 6c 64 20 | 61 20 66 69 6c 74 65 72 |o build |a filter|
|00002ed0| 20 6f 6e 20 61 20 52 65 | 63 6f 72 64 73 65 74 2e | on a Re|cordset.|
|00002ee0| 20 20 54 68 69 73 20 69 | 73 20 61 20 53 45 52 56 | This i|s a SERV|
|00002ef0| 45 52 20 53 49 44 45 20 | 63 6f 6e 74 72 61 63 74 |ER SIDE |contract|
|00002f00| 20 77 68 69 63 68 20 6d | 65 61 6e 73 20 74 68 61 | which m|eans tha|
|00002f10| 74 20 75 73 65 72 73 20 | 77 69 74 68 20 62 72 6f |t users |with bro|
|00002f20| 77 73 65 72 73 20 74 68 | 61 74 20 64 6f 20 6e 6f |wsers th|at do no|
|00002f30| 74 20 73 75 70 70 6f 72 | 74 20 4a 61 76 61 53 63 |t suppor|t JavaSc|
|00002f40| 72 69 70 74 20 63 61 6e | 20 73 74 69 6c 6c 20 62 |ript can| still b|
|00002f50| 72 6f 77 73 65 20 74 68 | 69 73 20 70 61 67 65 2e |rowse th|is page.|
|00002f60| 0d 0a 0d 0a 50 61 72 61 | 6d 65 74 65 72 73 3a 0d |....Para|meters:.|
|00002f70| 0a 43 6c 61 75 73 65 20 | 53 65 70 61 72 61 74 6f |.Clause |Separato|
|00002f80| 72 20 2d 20 65 69 74 68 | 65 72 20 22 28 22 2c 20 |r - eith|er "(", |
|00002f90| 22 29 22 2c 20 6f 72 20 | 22 20 22 0d 0a 43 6f 6e |")", or |" "..Con|
|00002fa0| 6e 65 63 74 6f 72 20 2d | 20 64 65 74 65 72 6d 69 |nector -| determi|
|00002fb0| 6e 65 73 20 68 6f 77 20 | 74 68 65 20 64 72 6f 70 |nes how |the drop|
|00002fc0| 64 6f 77 6e 20 6c 69 73 | 74 20 77 69 6c 6c 20 62 |down lis|t will b|
|00002fd0| 65 20 63 6f 6e 6e 65 63 | 74 65 64 20 74 6f 20 74 |e connec|ted to t|
|00002fe0| 68 65 20 65 78 69 73 74 | 69 6e 67 20 66 69 6c 74 |he exist|ing filt|
|00002ff0| 65 72 2c 20 65 69 74 68 | 65 72 20 41 4e 44 20 6f |er, eith|er AND o|
|00003000| 72 20 4f 52 2e 20 4c 45 | 41 56 45 20 42 4c 41 4e |r OR. LE|AVE BLAN|
|00003010| 4b 20 69 66 20 74 68 69 | 73 20 69 73 20 74 68 65 |K if thi|s is the|
|00003020| 20 66 69 72 73 74 20 66 | 6f 72 6d 20 65 6c 65 6d | first f|orm elem|
|00003030| 65 6e 74 20 69 6e 20 74 | 68 65 20 66 69 6c 74 65 |ent in t|he filte|
|00003040| 72 2e 0d 0a 4f 70 65 72 | 61 74 6f 72 20 2d 20 74 |r...Oper|ator - t|
|00003050| 68 65 20 77 61 79 20 74 | 68 65 20 64 61 74 61 20 |he way t|he data |
|00003060| 74 68 65 20 75 73 65 72 | 20 73 65 6c 65 63 74 73 |the user| selects|
|00003070| 20 69 6e 20 74 68 65 20 | 64 72 6f 70 64 6f 77 6e | in the |dropdown|
|00003080| 20 6c 69 73 74 20 69 73 | 20 74 6f 20 62 65 20 63 | list is| to be c|
|00003090| 6f 6d 70 61 72 65 64 20 | 74 6f 20 74 68 65 20 64 |ompared |to the d|
|000030a0| 61 74 61 20 69 6e 20 74 | 68 61 74 20 67 69 76 65 |ata in t|hat give|
|000030b0| 6e 20 66 69 65 6c 64 20 | 6f 66 20 74 68 65 20 52 |n field |of the R|
|000030c0| 65 63 6f 72 64 73 65 74 | 2e 20 47 72 65 61 74 65 |ecordset|. Greate|
|000030d0| 72 20 74 68 61 6e 2c 20 | 6c 65 73 73 20 74 68 61 |r than, |less tha|
|000030e0| 6e 2c 20 65 71 75 61 6c | 20 74 6f 2c 20 65 74 63 |n, equal| to, etc|
|000030f0| 2e 0d 0a 52 65 63 6f 72 | 64 73 65 74 20 46 69 65 |...Recor|dset Fie|
|00003100| 6c 64 20 2d 20 74 68 65 | 20 66 69 65 6c 64 20 6f |ld - the| field o|
|00003110| 6e 20 74 68 65 20 52 65 | 63 6f 72 64 73 65 74 20 |n the Re|cordset |
|00003120| 74 68 61 74 20 69 73 20 | 74 6f 20 62 65 20 75 73 |that is |to be us|
|00003130| 65 64 20 74 6f 20 63 6f | 6d 70 61 72 65 20 74 6f |ed to co|mpare to|
|00003140| 20 74 68 65 20 76 61 6c | 75 65 20 69 6e 20 74 68 | the val|ue in th|
|00003150| 65 20 64 72 6f 70 64 6f | 77 6e 20 6c 69 73 74 2e |e dropdo|wn list.|
|00003160| 0d 0a 0d 0a 54 79 70 69 | 63 61 6c 20 50 61 72 74 |....Typi|cal Part|
|00003170| 69 63 69 70 61 6e 74 73 | 3a 0d 0a 5b 52 65 63 6f |icipants|:..[Reco|
|00003180| 72 64 73 65 74 5d 20 2d | 20 61 20 52 65 63 6f 72 |rdset] -| a Recor|
|00003190| 64 73 65 74 0d 0a 5b 56 | 61 6c 75 65 20 49 6e 5d |dset..[V|alue In]|
|000031a0| 20 2d 20 61 20 64 72 6f | 70 64 6f 77 6e 20 6c 69 | - a dro|pdown li|
|000031b0| 73 74 20 77 68 6f 73 65 | 20 22 76 61 6c 75 65 22 |st whose| "value"|
|000031c0| 2c 20 6e 6f 74 20 6e 65 | 63 65 73 73 61 72 69 6c |, not ne|cessaril|
|000031d0| 79 20 76 69 73 69 62 6c | 65 20 74 65 78 74 2c 20 |y visibl|e text, |
|000031e0| 77 69 6c 6c 20 62 65 20 | 73 75 62 6d 69 74 74 65 |will be |submitte|
|000031f0| 64 0d 0a 5b 42 75 74 74 | 6f 6e 5d 20 2d 20 61 6e |d..[Butt|on] - an|
|00003200| 20 69 6d 61 67 65 20 6f | 72 20 66 6f 72 6d 20 62 | image o|r form b|
|00003210| 75 74 74 6f 6e 0d 0a 0d | 0a 4e 6f 74 65 3a 20 41 |utton...|.Note: A|
|00003220| 6e 79 20 64 72 6f 70 64 | 6f 77 6e 20 6c 69 73 74 |ny dropd|own list|
|00003230| 20 74 68 61 74 20 69 73 | 20 6c 65 66 74 20 62 6c | that is| left bl|
|00003240| 61 6e 6b 20 62 79 20 74 | 68 65 20 75 73 65 72 20 |ank by t|he user |
|00003250| 77 69 6c 6c 20 6e 6f 74 | 20 62 65 20 61 64 64 65 |will not| be adde|
|00003260| 64 20 74 6f 20 74 68 65 | 20 66 69 6c 74 65 72 2e |d to the| filter.|
|00003270| 0d 0a 0d 0a 4e 6f 74 65 | 3a 20 54 68 69 73 20 63 |....Note|: This c|
|00003280| 6f 6e 74 72 61 63 74 20 | 69 73 20 74 6f 20 62 65 |ontract |is to be|
|00003290| 20 75 73 65 64 20 69 6e | 20 63 6f 6e 6a 75 6e 63 | used in| conjunc|
|000032a0| 74 69 6f 6e 20 77 69 74 | 68 20 74 68 65 20 63 6f |tion wit|h the co|
|000032b0| 6e 74 72 61 63 74 20 22 | 46 69 6c 74 65 72 20 5b |ntract "|Filter [|
|000032c0| 52 65 63 6f 72 64 73 65 | 74 5d 20 77 68 65 6e 20 |Recordse|t] when |
|000032d0| 5b 73 6f 75 72 63 65 5d | 20 62 75 74 74 6f 6e 20 |[source]| button |
|000032e0| 69 73 20 63 6c 69 63 6b | 65 64 22 0d 0a 0d 0a 53 |is click|ed"....S|
|000032f0| 65 65 20 44 61 74 61 62 | 61 73 65 46 69 6c 74 65 |ee Datab|aseFilte|
|00003300| 72 56 31 30 5f 33 30 2e | 64 6f 63 20 66 6f 72 20 |rV10_30.|doc for |
|00003310| 67 65 6e 65 72 61 6c 20 | 69 6e 66 6f 72 6d 61 74 |general |informat|
|00003320| 69 6f 6e 20 6f 6e 20 44 | 61 74 61 62 61 73 65 20 |ion on D|atabase |
|00003330| 46 69 6c 74 65 72 20 63 | 6f 6e 74 72 61 63 74 73 |Filter c|ontracts|
|00003340| 2e 20 20 04 80 12 00 00 | 00 4a 41 64 64 20 5b 76 |. .....|.JAdd [v|
|00003350| 61 6c 75 65 20 69 6e 5d | 20 63 68 65 63 6b 20 62 |alue in]| check b|
|00003360| 6f 78 20 74 6f 20 66 69 | 6c 74 65 72 20 6f 66 20 |ox to fi|lter of |
|00003370| 5b 52 65 63 6f 72 64 73 | 65 74 5d 20 77 68 65 6e |[Records|et] when|
|00003380| 20 5b 42 75 74 74 6f 6e | 5d 20 69 73 20 63 6c 69 | [Button|] is cli|
|00003390| 63 6b 65 64 00 00 00 00 | 00 03 00 06 80 01 00 00 |cked....|........|
|000033a0| 00 08 56 61 6c 75 65 20 | 49 6e 01 00 08 80 03 00 |..Value |In......|
|000033b0| 00 00 01 00 00 00 0a 67 | 65 74 53 74 61 74 65 28 |.......g|etState(|
|000033c0| 29 00 00 06 80 01 00 00 | 00 09 52 65 63 6f 72 64 |).......|..Record|
|000033d0| 73 65 74 02 00 08 80 03 | 00 00 00 00 00 00 00 0c |set.....|........|
|000033e0| 42 65 66 6f 72 65 4f 70 | 65 6e 28 29 08 80 03 00 |BeforeOp|en()....|
|000033f0| 00 00 01 00 00 00 0a 4d | 6f 76 65 4e 65 78 74 28 |.......M|oveNext(|
|00003400| 29 01 00 10 80 04 00 00 | 00 0c 42 65 66 6f 72 65 |).......|..Before|
|00003410| 4f 70 65 6e 28 29 02 00 | 00 00 00 00 00 00 ab 69 |Open()..|.......i|
|00003420| 66 20 28 52 65 71 75 65 | 73 74 2e 46 6f 72 6d 2e |f (Reque|st.Form.|
|00003430| 4b 65 79 28 22 5b 42 75 | 74 74 6f 6e 5d 22 29 20 |Key("[Bu|tton]") |
|00003440| 21 3d 20 22 22 29 0d 0a | 7b 0d 0a 20 20 20 20 41 |!= "")..|{.. A|
|00003450| 64 64 54 6f 46 69 6c 74 | 65 72 28 5b 52 65 63 6f |ddToFilt|er([Reco|
|00003460| 72 64 73 65 74 5d 2c 20 | 22 5b 56 61 6c 75 65 20 |rdset], |"[Value |
|00003470| 49 6e 5d 22 2c 20 5b 52 | 65 63 6f 72 64 73 65 74 |In]", [R|ecordset|
|00003480| 20 46 69 65 6c 64 5d 2c | 20 22 3d 22 20 2f 2a 4f | Field],| "=" /*O|
|00003490| 70 65 72 61 74 6f 72 2a | 2f 2c 20 5b 43 6f 6e 6e |perator*|/, [Conn|
|000034a0| 65 63 74 6f 72 5d 2c 20 | 22 43 68 65 63 6b 42 6f |ector], |"CheckBo|
|000034b0| 78 22 2c 20 5b 43 6c 61 | 75 73 65 20 53 65 70 61 |x", [Cla|use Sepa|
|000034c0| 72 61 74 6f 72 5d 29 0d | 0a 7d 01 00 00 00 a3 69 |rator]).|.}.....i|
|000034d0| 66 20 52 65 71 75 65 73 | 74 2e 46 6f 72 6d 2e 4b |f Reques|t.Form.K|
|000034e0| 65 79 28 22 5b 42 75 74 | 74 6f 6e 5d 22 29 20 3c |ey("[But|ton]") <|
|000034f0| 3e 20 22 22 20 74 68 65 | 6e 0d 0a 20 20 20 20 41 |> "" the|n.. A|
|00003500| 64 64 54 6f 46 69 6c 74 | 65 72 20 5b 52 65 63 6f |ddToFilt|er [Reco|
|00003510| 72 64 73 65 74 5d 2c 20 | 22 5b 56 61 6c 75 65 20 |rdset], |"[Value |
|00003520| 49 6e 5d 22 2c 20 5b 52 | 65 63 6f 72 64 73 65 74 |In]", [R|ecordset|
|00003530| 20 46 69 65 6c 64 5d 2c | 20 22 3d 22 20 2c 20 5b | Field],| "=" , [|
|00003540| 43 6f 6e 6e 65 63 74 6f | 72 5d 2c 20 22 43 68 65 |Connecto|r], "Che|
|00003550| 63 6b 42 6f 78 22 2c 20 | 5b 43 6c 61 75 73 65 20 |ckBox", |[Clause |
|00003560| 53 65 70 61 72 61 74 6f | 72 5d 0d 0a 65 6e 64 20 |Separato|r]..end |
|00003570| 69 66 06 80 01 00 00 00 | 06 42 75 74 74 6f 6e 01 |if......|.Button.|
|00003580| 00 08 80 03 00 00 00 00 | 00 00 00 07 6f 6e 43 6c |........|....onCl|
|00003590| 69 63 6b 00 00 03 00 13 | 80 05 00 00 00 09 43 6f |ick.....|......Co|
|000035a0| 6e 6e 65 63 74 6f 72 04 | 00 00 00 08 00 02 00 00 |nnector.|........|
|000035b0| 00 20 00 03 00 01 20 03 | 41 4e 44 02 4f 52 00 00 |. .... .|AND.OR..|
|000035c0| 00 00 00 00 00 00 00 13 | 80 05 00 00 00 0f 52 65 |........|......Re|
|000035d0| 63 6f 72 64 73 65 74 20 | 46 69 65 6c 64 04 00 00 |cordset |Field...|
|000035e0| 00 08 00 00 00 00 00 00 | 00 01 00 00 00 09 52 65 |........|......Re|
|000035f0| 63 6f 72 64 73 65 74 00 | 00 00 00 13 80 05 00 00 |cordset.|........|
|00003600| 00 10 43 6c 61 75 73 65 | 20 53 65 70 61 72 61 74 |..Clause| Separat|
|00003610| 6f 72 04 00 00 00 08 00 | 02 00 00 00 20 00 03 00 |or......|.... ...|
|00003620| 01 20 01 28 01 29 00 00 | 00 00 00 00 00 00 00 0f |. .(.)..|........|
|00003630| 44 61 74 61 62 61 73 65 | 20 46 69 6c 74 65 72 01 |Database| Filter.|
|00003640| 00 41 83 5d a7 ea 80 d2 | 11 80 51 00 10 4b d3 38 |.A.]....|..Q..K.8|
|00003650| d1 00 00 00 00 04 00 00 | 00 01 00 00 00 01 00 10 |........|........|
|00003660| 80 04 00 00 00 06 53 65 | 72 76 65 72 01 00 00 00 |......Se|rver....|
|00003670| 00 00 00 00 00 dc d3 ff | 19 e8 80 d2 11 80 51 00 |........|......Q.|
|00003680| 10 4b d3 38 d1 01 00 00 | 00 24 33 37 37 41 43 34 |.K.8....|.$377AC4|
|00003690| 33 30 2d 36 32 31 31 2d | 31 31 44 32 2d 38 31 31 |30-6211-|11D2-811|
|000036a0| 37 2d 30 30 36 30 30 38 | 43 38 36 43 32 35 03 33 |7-006008|C86C25.3|
|000036b0| 2e 30 ff 53 03 56 31 30 | 5f 33 30 0d 0a 44 65 73 |.0.S.V10|_30..Des|
|000036c0| 63 72 69 70 74 69 6f 6e | 3a 0d 0a 54 68 69 73 20 |cription|:..This |
|000036d0| 69 6e 74 65 72 61 63 74 | 69 6f 6e 20 69 73 20 75 |interact|ion is u|
|000036e0| 73 65 64 20 74 6f 20 62 | 75 69 6c 64 20 61 20 66 |sed to b|uild a f|
|000036f0| 69 6c 74 65 72 20 6f 6e | 20 61 20 52 65 63 6f 72 |ilter on| a Recor|
|00003700| 64 73 65 74 2e 20 20 54 | 68 69 73 20 69 73 20 61 |dset. T|his is a|
|00003710| 20 53 45 52 56 45 52 20 | 53 49 44 45 20 63 6f 6e | SERVER |SIDE con|
|00003720| 74 72 61 63 74 20 77 68 | 69 63 68 20 6d 65 61 6e |tract wh|ich mean|
|00003730| 73 20 74 68 61 74 20 75 | 73 65 72 73 20 77 69 74 |s that u|sers wit|
|00003740| 68 20 62 72 6f 77 73 65 | 72 73 20 74 68 61 74 20 |h browse|rs that |
|00003750| 64 6f 20 6e 6f 74 20 73 | 75 70 70 6f 72 74 20 4a |do not s|upport J|
|00003760| 61 76 61 53 63 72 69 70 | 74 20 63 61 6e 20 73 74 |avaScrip|t can st|
|00003770| 69 6c 6c 20 62 72 6f 77 | 73 65 20 74 68 69 73 20 |ill brow|se this |
|00003780| 70 61 67 65 2e 0d 0a 0d | 0a 50 61 72 61 6d 65 74 |page....|.Paramet|
|00003790| 65 72 73 3a 0d 0a 43 6c | 61 75 73 65 20 53 65 70 |ers:..Cl|ause Sep|
|000037a0| 61 72 61 74 6f 72 20 2d | 20 65 69 74 68 65 72 20 |arator -| either |
|000037b0| 22 28 22 2c 20 22 29 22 | 2c 20 6f 72 20 22 20 22 |"(", ")"|, or " "|
|000037c0| 0d 0a 43 6f 6e 6e 65 63 | 74 6f 72 20 2d 20 64 65 |..Connec|tor - de|
|000037d0| 74 65 72 6d 69 6e 65 73 | 20 68 6f 77 20 74 68 65 |termines| how the|
|000037e0| 20 63 68 65 63 6b 20 62 | 6f 78 20 77 69 6c 6c 20 | check b|ox will |
|000037f0| 62 65 20 63 6f 6e 6e 65 | 63 74 65 64 20 74 6f 20 |be conne|cted to |
|00003800| 74 68 65 20 65 78 69 73 | 74 69 6e 67 20 66 69 6c |the exis|ting fil|
|00003810| 74 65 72 2c 20 65 69 74 | 68 65 72 20 41 4e 44 20 |ter, eit|her AND |
|00003820| 6f 72 20 4f 52 2e 20 4c | 45 41 56 45 20 42 4c 41 |or OR. L|EAVE BLA|
|00003830| 4e 4b 20 69 66 20 74 68 | 69 73 20 69 73 20 74 68 |NK if th|is is th|
|00003840| 65 20 66 69 72 73 74 20 | 66 6f 72 6d 20 65 6c 65 |e first |form ele|
|00003850| 6d 65 6e 74 20 69 6e 20 | 74 68 65 20 66 69 6c 74 |ment in |the filt|
|00003860| 65 72 2e 0d 0a 52 65 63 | 6f 72 64 73 65 74 20 46 |er...Rec|ordset F|
|00003870| 69 65 6c 64 20 2d 20 74 | 68 65 20 66 69 65 6c 64 |ield - t|he field|
|00003880| 20 6f 6e 20 74 68 65 20 | 52 65 63 6f 72 64 73 65 | on the |Recordse|
|00003890| 74 20 74 68 61 74 20 69 | 73 20 74 6f 20 62 65 20 |t that i|s to be |
|000038a0| 75 73 65 64 20 74 6f 20 | 63 6f 6d 70 61 72 65 20 |used to |compare |
|000038b0| 74 6f 20 74 68 65 20 63 | 68 65 63 6b 20 62 6f 78 |to the c|heck box|
|000038c0| 2e 0d 0a 0d 0a 54 79 70 | 69 63 61 6c 20 50 61 72 |.....Typ|ical Par|
|000038d0| 74 69 63 69 70 61 6e 74 | 73 3a 0d 0a 5b 52 65 63 |ticipant|s:..[Rec|
|000038e0| 6f 72 64 73 65 74 5d 20 | 2d 20 61 20 52 65 63 6f |ordset] |- a Reco|
|000038f0| 72 64 73 65 74 0d 0a 5b | 56 61 6c 75 65 20 49 6e |rdset..[|Value In|
|00003900| 5d 20 2d 20 61 20 63 68 | 65 63 6b 20 62 6f 78 0d |] - a ch|eck box.|
|00003910| 0a 5b 42 75 74 74 6f 6e | 5d 20 2d 20 61 6e 20 69 |.[Button|] - an i|
|00003920| 6d 61 67 65 20 6f 72 20 | 66 6f 72 6d 20 62 75 74 |mage or |form but|
|00003930| 74 6f 6e 0d 0a 0d 0a 4e | 6f 74 65 3a 20 54 68 69 |ton....N|ote: Thi|
|00003940| 73 20 63 6f 6e 74 72 61 | 63 74 20 69 73 20 74 6f |s contra|ct is to|
|00003950| 20 62 65 20 75 73 65 64 | 20 69 6e 20 63 6f 6e 6a | be used| in conj|
|00003960| 75 6e 63 74 69 6f 6e 20 | 77 69 74 68 20 74 68 65 |unction |with the|
|00003970| 20 63 6f 6e 74 72 61 63 | 74 20 22 46 69 6c 74 65 | contrac|t "Filte|
|00003980| 72 20 5b 52 65 63 6f 72 | 64 73 65 74 5d 20 77 68 |r [Recor|dset] wh|
|00003990| 65 6e 20 5b 73 6f 75 72 | 63 65 5d 20 62 75 74 74 |en [sour|ce] butt|
|000039a0| 6f 6e 20 69 73 20 63 6c | 69 63 6b 65 64 22 0d 0a |on is cl|icked"..|
|000039b0| 0d 0a 53 65 65 20 44 61 | 74 61 62 61 73 65 46 69 |..See Da|tabaseFi|
|000039c0| 6c 74 65 72 56 31 30 5f | 33 30 2e 64 6f 63 20 66 |lterV10_|30.doc f|
|000039d0| 6f 72 20 67 65 6e 65 72 | 61 6c 20 69 6e 66 6f 72 |or gener|al infor|
|000039e0| 6d 61 74 69 6f 6e 20 6f | 6e 20 44 61 74 61 62 61 |mation o|n Databa|
|000039f0| 73 65 20 46 69 6c 74 65 | 72 20 63 6f 6e 74 72 61 |se Filte|r contra|
|00003a00| 63 74 73 2e 20 20 0d 0a | 04 80 12 00 00 00 32 46 |cts. ..|......2F|
|00003a10| 69 6c 74 65 72 20 5b 52 | 65 63 6f 72 64 73 65 74 |ilter [R|ecordset|
|00003a20| 5d 20 77 68 65 6e 20 5b | 73 6f 75 72 63 65 5d 20 |] when [|source] |
|00003a30| 62 75 74 74 6f 6e 20 69 | 73 20 63 6c 69 63 6b 65 |button i|s clicke|
|00003a40| 64 00 00 00 00 00 02 00 | 06 80 01 00 00 00 06 53 |d.......|.......S|
|00003a50| 6f 75 72 63 65 01 00 08 | 80 03 00 00 00 00 00 00 |ource...|........|
|00003a60| 00 07 6f 6e 43 6c 69 63 | 6b 00 00 06 80 01 00 00 |..onClic|k.......|
|00003a70| 00 09 52 65 63 6f 72 64 | 73 65 74 03 00 08 80 03 |..Record|set.....|
|00003a80| 00 00 00 00 00 00 00 0c | 42 65 66 6f 72 65 4f 70 |........|BeforeOp|
|00003a90| 65 6e 28 29 08 80 03 00 | 00 00 00 00 00 00 08 53 |en()....|.......S|
|00003aa0| 65 72 76 65 72 28 29 08 | 80 03 00 00 00 01 00 00 |erver().|........|
|00003ab0| 00 0a 4d 6f 76 65 4e 65 | 78 74 28 29 02 00 10 80 |..MoveNe|xt()....|
|00003ac0| 04 00 00 00 0c 42 65 66 | 6f 72 65 4f 70 65 6e 28 |.....Bef|oreOpen(|
|00003ad0| 29 01 00 00 00 01 00 00 | 00 00 10 80 04 00 00 00 |).......|........|
|00003ae0| 08 53 65 72 76 65 72 28 | 29 02 00 00 00 00 00 00 |.Server(|).......|
|00003af0| 00 a0 69 66 20 28 52 65 | 71 75 65 73 74 2e 46 6f |..if (Re|quest.Fo|
|00003b00| 72 6d 2e 4b 65 79 28 22 | 5b 53 6f 75 72 63 65 5d |rm.Key("|[Source]|
|00003b10| 22 29 20 21 3d 20 22 22 | 29 0d 0a 7b 0d 0a 20 20 |") != ""|)..{.. |
|00003b20| 20 20 52 65 73 70 6f 6e | 73 65 2e 52 65 64 69 72 | Respon|se.Redir|
|00003b30| 65 63 74 28 65 73 63 61 | 70 65 28 5b 47 6f 20 54 |ect(esca|pe([Go T|
|00003b40| 6f 20 50 61 67 65 5d 29 | 20 2b 20 22 3f 5b 52 65 |o Page])| + "?[Re|
|00003b50| 63 6f 72 64 73 65 74 5d | 5f 41 63 74 69 6f 6e 3d |cordset]|_Action=|
|00003b60| 22 20 2b 20 53 65 72 76 | 65 72 2e 55 52 4c 45 6e |" + Serv|er.URLEn|
|00003b70| 63 6f 64 65 28 5b 52 65 | 63 6f 72 64 73 65 74 5d |code([Re|cordset]|
|00003b80| 2e 46 69 6c 74 65 72 53 | 74 72 69 6e 67 29 29 0d |.FilterS|tring)).|
|00003b90| 0a 7d 01 00 00 00 ae 69 | 66 20 52 65 71 75 65 73 |.}.....i|f Reques|
|00003ba0| 74 2e 46 6f 72 6d 2e 4b | 65 79 28 22 5b 53 6f 75 |t.Form.K|ey("[Sou|
|00003bb0| 72 63 65 5d 22 29 20 3c | 3e 20 22 22 20 74 68 65 |rce]") <|> "" the|
|00003bc0| 6e 0d 0a 20 20 20 20 52 | 65 73 70 6f 6e 73 65 2e |n.. R|esponse.|
|00003bd0| 52 65 64 69 72 65 63 74 | 28 55 52 4c 45 73 63 61 |Redirect|(URLEsca|
|00003be0| 70 65 53 70 61 63 65 73 | 28 5b 47 6f 20 54 6f 20 |peSpaces|([Go To |
|00003bf0| 50 61 67 65 5d 29 20 26 | 20 22 3f 5b 52 65 63 6f |Page]) &| "?[Reco|
|00003c00| 72 64 73 65 74 5d 5f 41 | 63 74 69 6f 6e 3d 22 20 |rdset]_A|ction=" |
|00003c10| 26 20 53 65 72 76 65 72 | 2e 55 52 4c 45 6e 63 6f |& Server|.URLEnco|
|00003c20| 64 65 28 5b 52 65 63 6f | 72 64 73 65 74 5d 2e 46 |de([Reco|rdset].F|
|00003c30| 69 6c 74 65 72 53 74 72 | 69 6e 67 29 29 0d 0a 65 |ilterStr|ing))..e|
|00003c40| 6e 64 20 69 66 01 00 13 | 80 05 00 00 00 0a 47 6f |nd if...|......Go|
|00003c50| 20 54 6f 20 50 61 67 65 | 06 00 00 00 03 00 01 00 | To Page|........|
|00003c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 0f 44 61 |........|......Da|
|00003c70| 74 61 62 61 73 65 20 46 | 69 6c 74 65 72 02 00 41 |tabase F|ilter..A|
|00003c80| 83 5d a7 ea 80 d2 11 80 | 51 00 10 4b d3 38 d1 e0 |.]......|Q..K.8..|
|00003c90| 5a 9c 93 23 83 d2 11 80 | 52 00 10 4b d3 38 d1 00 |Z..#....|R..K.8..|
|00003ca0| 00 00 00 04 00 00 00 01 | 00 00 00 01 00 10 80 04 |........|........|
|00003cb0| 00 00 00 06 53 65 72 76 | 65 72 01 00 00 00 00 00 |....Serv|er......|
|00003cc0| 00 00 00 5f 71 81 d3 dd | 80 d2 11 80 51 00 10 4b |..._q...|....Q..K|
|00003cd0| d3 38 d1 01 00 00 00 24 | 33 37 37 41 43 34 33 30 |.8.....$|377AC430|
|00003ce0| 2d 36 32 31 31 2d 31 31 | 44 32 2d 38 31 31 37 2d |-6211-11|D2-8117-|
|00003cf0| 30 30 36 30 30 38 43 38 | 36 43 32 35 03 33 2e 30 |006008C8|6C25.3.0|
|00003d00| ff 32 03 56 31 30 5f 33 | 30 0d 0a 44 65 73 63 72 |.2.V10_3|0..Descr|
|00003d10| 69 70 74 69 6f 6e 3a 0d | 0a 54 68 69 73 20 69 6e |iption:.|.This in|
|00003d20| 74 65 72 61 63 74 69 6f | 6e 20 69 73 20 75 73 65 |teractio|n is use|
|00003d30| 64 20 74 6f 20 62 75 69 | 6c 64 20 61 20 66 69 6c |d to bui|ld a fil|
|00003d40| 74 65 72 20 6f 6e 20 61 | 20 52 65 63 6f 72 64 73 |ter on a| Records|
|00003d50| 65 74 2e 20 20 54 68 69 | 73 20 69 73 20 61 20 53 |et. Thi|s is a S|
|00003d60| 45 52 56 45 52 20 53 49 | 44 45 20 63 6f 6e 74 72 |ERVER SI|DE contr|
|00003d70| 61 63 74 20 77 68 69 63 | 68 20 6d 65 61 6e 73 20 |act whic|h means |
|00003d80| 74 68 61 74 20 75 73 65 | 72 73 20 77 69 74 68 20 |that use|rs with |
|00003d90| 62 72 6f 77 73 65 72 73 | 20 74 68 61 74 20 64 6f |browsers| that do|
|00003da0| 20 6e 6f 74 20 73 75 70 | 70 6f 72 74 20 4a 61 76 | not sup|port Jav|
|00003db0| 61 53 63 72 69 70 74 20 | 63 61 6e 20 73 74 69 6c |aScript |can stil|
|00003dc0| 6c 20 62 72 6f 77 73 65 | 20 74 68 69 73 20 70 61 |l browse| this pa|
|00003dd0| 67 65 2e 20 20 4d 61 6b | 65 20 73 75 72 65 20 74 |ge. Mak|e sure t|
|00003de0| 68 61 74 20 74 68 65 20 | 61 63 74 69 6f 6e 20 6f |hat the |action o|
|00003df0| 66 20 74 68 65 20 66 6f | 72 6d 20 6f 6e 20 74 68 |f the fo|rm on th|
|00003e00| 69 73 20 70 61 67 65 20 | 69 73 20 65 69 74 68 65 |is page |is eithe|
|00003e10| 72 20 62 6c 61 6e 6b 2c | 20 6f 72 20 74 68 69 73 |r blank,| or this|
|00003e20| 20 70 61 67 65 27 73 20 | 6e 61 6d 65 2e 0d 0a 0d | page's |name....|
|00003e30| 0a 50 61 72 61 6d 65 74 | 65 72 73 3a 0d 0a 47 6f |.Paramet|ers:..Go|
|00003e40| 20 54 6f 20 50 61 67 65 | 20 2d 20 73 65 6c 65 63 | To Page| - selec|
|00003e50| 74 20 74 68 65 20 70 61 | 67 65 20 74 68 61 74 20 |t the pa|ge that |
|00003e60| 79 6f 75 20 77 61 6e 74 | 20 74 68 65 20 75 73 65 |you want| the use|
|00003e70| 72 20 74 6f 20 62 65 20 | 72 65 64 69 72 65 63 74 |r to be |redirect|
|00003e80| 65 64 2e 20 20 54 68 69 | 73 20 69 73 20 6c 69 6b |ed. Thi|s is lik|
|00003e90| 65 20 61 73 73 69 67 6e | 69 6e 67 20 74 68 65 20 |e assign|ing the |
|00003ea0| 61 63 74 69 6f 6e 20 6f | 66 20 74 68 65 20 66 6f |action o|f the fo|
|00003eb0| 72 6d 2e 20 28 4e 6f 74 | 65 3a 20 74 68 65 20 61 |rm. (Not|e: the a|
|00003ec0| 63 74 75 61 6c 20 61 63 | 74 69 6f 6e 20 6f 66 20 |ctual ac|tion of |
|00003ed0| 74 68 65 20 66 6f 72 6d | 20 73 68 6f 75 6c 64 20 |the form| should |
|00003ee0| 62 65 20 74 68 69 73 20 | 70 61 67 65 20 69 74 73 |be this |page its|
|00003ef0| 65 6c 66 2e 20 20 54 68 | 65 20 75 73 65 72 20 77 |elf. Th|e user w|
|00003f00| 69 6c 6c 20 74 68 65 6e | 20 62 65 20 72 65 64 69 |ill then| be redi|
|00003f10| 72 65 63 74 65 64 20 74 | 6f 20 47 6f 20 54 6f 20 |rected t|o Go To |
|00003f20| 50 61 67 65 29 0d 0a 0d | 0a 54 79 70 69 63 61 6c |Page)...|.Typical|
|00003f30| 20 50 61 72 74 69 63 69 | 70 61 6e 74 73 3a 0d 0a | Partici|pants:..|
|00003f40| 5b 52 65 63 6f 72 64 73 | 65 74 5d 20 2d 20 61 20 |[Records|et] - a |
|00003f50| 52 65 63 6f 72 64 73 65 | 74 0d 0a 5b 53 6f 75 72 |Recordse|t..[Sour|
|00003f60| 63 65 5d 20 2d 20 61 20 | 73 75 62 6d 69 74 20 62 |ce] - a |submit b|
|00003f70| 75 74 74 6f 6e 0d 0a 0d | 0a 4e 6f 74 65 3a 20 54 |utton...|.Note: T|
|00003f80| 68 69 73 20 63 6f 6e 74 | 72 61 63 74 20 69 73 20 |his cont|ract is |
|00003f90| 74 6f 20 62 65 20 75 73 | 65 64 20 69 6e 20 63 6f |to be us|ed in co|
|00003fa0| 6e 6a 75 6e 63 74 69 6f | 6e 20 77 69 74 68 20 74 |njunctio|n with t|
|00003fb0| 68 65 20 6f 74 68 65 72 | 20 28 47 65 6e 65 72 69 |he other| (Generi|
|00003fc0| 63 29 20 44 61 74 61 62 | 61 73 65 20 46 69 6c 74 |c) Datab|ase Filt|
|00003fd0| 65 72 20 63 6f 6e 74 72 | 61 63 74 73 2e 0d 0a 0d |er contr|acts....|
|00003fe0| 0a 53 65 65 20 44 61 74 | 61 62 61 73 65 46 69 6c |.See Dat|abaseFil|
|00003ff0| 74 65 72 56 31 30 5f 33 | 30 2e 64 6f 63 20 66 6f |terV10_3|0.doc fo|
|00004000| 72 20 67 65 6e 65 72 61 | 6c 20 69 6e 66 6f 72 6d |r genera|l inform|
|00004010| 61 74 69 6f 6e 20 6f 6e | 20 44 61 74 61 62 61 73 |ation on| Databas|
|00004020| 65 20 46 69 6c 74 65 72 | 20 63 6f 6e 74 72 61 63 |e Filter| contrac|
|00004030| 74 73 2e 20 20 04 80 12 | 00 00 00 00 01 00 00 00 |ts. ...|........|
|00004040| 41 46 69 6c 74 65 72 20 | 5b 52 65 63 6f 72 64 73 |AFilter |[Records|
|00004050| 65 74 5d 20 77 69 74 68 | 20 66 69 6c 74 65 72 20 |et] with| filter |
|00004060| 73 74 72 69 6e 67 20 6f | 6e 20 73 65 72 76 65 72 |string o|n server|
|00004070| 20 62 65 66 6f 72 65 20 | 70 61 67 65 20 6c 6f 61 | before |page loa|
|00004080| 64 73 01 00 06 80 01 00 | 00 00 09 52 65 63 6f 72 |ds......|...Recor|
|00004090| 64 73 65 74 03 00 08 80 | 03 00 00 00 00 00 00 00 |dset....|........|
|000040a0| 08 53 65 72 76 65 72 28 | 29 08 80 03 00 00 00 01 |.Server(|).......|
|000040b0| 00 00 00 0a 4d 6f 76 65 | 4e 65 78 74 28 29 08 80 |....Move|Next()..|
|000040c0| 03 00 00 00 00 00 00 00 | 0c 42 65 66 6f 72 65 4f |........|.BeforeO|
|000040d0| 70 65 6e 28 29 02 00 10 | 80 04 00 00 00 0c 42 65 |pen()...|......Be|
|000040e0| 66 6f 72 65 4f 70 65 6e | 28 29 02 00 00 00 00 00 |foreOpen|()......|
|000040f0| 00 00 ff 1c 01 2f 2f 20 | 49 20 63 68 65 63 6b 20 |.....// |I check |
|00004100| 74 68 65 20 46 69 6c 74 | 65 72 43 72 69 74 65 72 |the Filt|erCriter|
|00004110| 69 61 2e 20 49 66 20 69 | 74 20 65 78 69 73 74 73 |ia. If i|t exists|
|00004120| 2c 20 74 68 65 20 72 65 | 63 6f 72 64 73 65 74 20 |, the re|cordset |
|00004130| 61 6c 72 65 61 64 79 0d | 0a 2f 2f 20 68 61 73 20 |already.|.// has |
|00004140| 61 20 66 69 6c 74 65 72 | 20 61 6e 64 20 77 65 20 |a filter| and we |
|00004150| 64 6f 6e 27 74 20 61 73 | 73 69 67 6e 20 74 68 65 |don't as|sign the|
|00004160| 20 61 63 74 69 6f 6e 2e | 20 20 49 20 64 6f 20 74 | action.| I do t|
|00004170| 68 69 73 20 73 6f 20 74 | 68 65 0d 0a 2f 2f 20 6e |his so t|he..// n|
|00004180| 61 76 69 67 61 74 69 6f | 6e 20 62 75 74 74 6f 6e |avigatio|n button|
|00004190| 73 20 77 69 6c 6c 20 77 | 6f 72 6b 20 70 72 6f 70 |s will w|ork prop|
|000041a0| 65 72 6c 79 0d 0a 69 66 | 20 28 5b 52 65 63 6f 72 |erly..if| ([Recor|
|000041b0| 64 73 65 74 5d 2e 46 69 | 6c 74 65 72 43 72 69 74 |dset].Fi|lterCrit|
|000041c0| 65 72 69 61 20 3d 3d 20 | 22 22 29 0d 0a 7b 0d 0a |eria == |"")..{..|
|000041d0| 20 20 20 20 5b 52 65 63 | 6f 72 64 73 65 74 5d 2e | [Rec|ordset].|
|000041e0| 41 63 74 69 6f 6e 20 3d | 20 22 46 69 6c 74 65 72 |Action =| "Filter|
|000041f0| 28 5c 22 22 20 2b 20 5b | 46 69 6c 74 65 72 20 53 |(\"" + [|Filter S|
|00004200| 74 72 69 6e 67 5d 20 2b | 20 22 5c 22 29 22 0d 0a |tring] +| "\")"..|
|00004210| 7d 01 00 00 00 ff 21 01 | 27 20 49 20 63 68 65 63 |}.....!.|' I chec|
|00004220| 6b 20 74 68 65 20 46 69 | 6c 74 65 72 43 72 69 74 |k the Fi|lterCrit|
|00004230| 65 72 69 61 2e 20 49 66 | 20 69 74 20 65 78 69 73 |eria. If| it exis|
|00004240| 74 73 2c 20 74 68 65 20 | 72 65 63 6f 72 64 73 65 |ts, the |recordse|
|00004250| 74 20 61 6c 72 65 61 64 | 79 0d 0a 27 20 68 61 73 |t alread|y..' has|
|00004260| 20 61 20 66 69 6c 74 65 | 72 20 61 6e 64 20 77 65 | a filte|r and we|
|00004270| 20 64 6f 6e 27 74 20 61 | 73 73 69 67 6e 20 74 68 | don't a|ssign th|
|00004280| 65 20 61 63 74 69 6f 6e | 2e 20 20 49 20 64 6f 20 |e action|. I do |
|00004290| 74 68 69 73 20 73 6f 20 | 74 68 65 0d 0a 27 20 6e |this so |the..' n|
|000042a0| 61 76 69 67 61 74 69 6f | 6e 20 62 75 74 74 6f 6e |avigatio|n button|
|000042b0| 73 20 77 69 6c 6c 20 77 | 6f 72 6b 20 70 72 6f 70 |s will w|ork prop|
|000042c0| 65 72 6c 79 0d 0a 69 66 | 20 5b 52 65 63 6f 72 64 |erly..if| [Record|
|000042d0| 73 65 74 5d 2e 46 69 6c | 74 65 72 43 72 69 74 65 |set].Fil|terCrite|
|000042e0| 72 69 61 20 3d 20 22 22 | 20 74 68 65 6e 0d 0a 0d |ria = ""| then...|
|000042f0| 0a 20 20 20 20 5b 52 65 | 63 6f 72 64 73 65 74 5d |. [Re|cordset]|
|00004300| 2e 41 63 74 69 6f 6e 20 | 3d 20 22 46 69 6c 74 65 |.Action |= "Filte|
|00004310| 72 28 22 22 22 20 26 20 | 5b 46 69 6c 74 65 72 20 |r(""" & |[Filter |
|00004320| 53 74 72 69 6e 67 5d 20 | 26 20 22 22 22 29 22 0d |String] |& """)".|
|00004330| 0a 0d 0a 65 6e 64 20 69 | 66 10 80 04 00 00 00 08 |...end i|f.......|
|00004340| 53 65 72 76 65 72 28 29 | 02 00 00 00 00 00 00 00 |Server()|........|
|00004350| 00 01 00 00 00 00 01 00 | 13 80 05 00 00 00 0d 46 |........|.......F|
|00004360| 69 6c 74 65 72 20 53 74 | 72 69 6e 67 00 00 00 00 |ilter St|ring....|
|00004370| 08 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004380| 00 0f 44 61 74 61 62 61 | 73 65 20 46 69 6c 74 65 |..Databa|se Filte|
|00004390| 72 00 00 00 00 00 00 04 | 00 00 00 01 00 00 00 01 |r.......|........|
|000043a0| 00 10 80 04 00 00 00 06 | 6f 6e 42 6c 75 72 01 00 |........|onBlur..|
|000043b0| 00 00 00 00 00 00 00 9f | a2 ab 9a aa 88 d2 11 80 |........|........|
|000043c0| 55 00 10 4b d3 38 d1 01 | 00 00 00 24 33 37 37 41 |U..K.8..|...$377A|
|000043d0| 43 34 33 30 2d 36 32 31 | 31 2d 31 31 44 32 2d 38 |C430-621|1-11D2-8|
|000043e0| 31 31 37 2d 30 30 36 30 | 30 38 43 38 36 43 32 35 |117-0060|08C86C25|
|000043f0| 03 33 2e 30 ff 66 02 56 | 31 30 5f 33 30 0d 0a 44 |.3.0.f.V|10_30..D|
|00004400| 65 73 63 72 69 70 74 69 | 6f 6e 3a 0d 0a 54 68 69 |escripti|on:..Thi|
|00004410| 73 20 69 6e 74 65 72 61 | 63 74 69 6f 6e 20 69 73 |s intera|ction is|
|00004420| 20 75 73 65 64 20 74 6f | 20 66 69 6c 74 65 72 20 | used to| filter |
|00004430| 61 20 52 65 63 6f 72 64 | 73 65 74 20 77 69 74 68 |a Record|set with|
|00004440| 20 74 68 65 20 75 73 65 | 72 2d 73 75 70 70 6c 69 | the use|r-suppli|
|00004450| 65 64 20 66 69 6c 74 65 | 72 20 73 74 72 69 6e 67 |ed filte|r string|
|00004460| 20 6f 6e 20 74 68 65 20 | 73 65 72 76 65 72 20 62 | on the |server b|
|00004470| 65 66 6f 72 65 20 74 68 | 65 20 70 61 67 65 20 6c |efore th|e page l|
|00004480| 6f 61 64 73 2e 20 4b 6e | 6f 77 6c 65 64 67 65 20 |oads. Kn|owledge |
|00004490| 6f 66 20 68 6f 77 20 74 | 6f 20 63 72 65 61 74 65 |of how t|o create|
|000044a0| 20 53 51 4c 20 77 68 65 | 72 65 20 63 6c 61 75 73 | SQL whe|re claus|
|000044b0| 65 73 20 69 73 20 75 73 | 65 66 75 6c 20 77 68 65 |es is us|eful whe|
|000044c0| 6e 20 75 73 69 6e 67 20 | 74 68 69 73 20 63 6f 6e |n using |this con|
|000044d0| 74 72 61 63 74 2e 0d 0a | 0d 0a 50 61 72 61 6d 65 |tract...|..Parame|
|000044e0| 74 65 72 73 3a 0d 0a 46 | 69 6c 74 65 72 20 53 74 |ters:..F|ilter St|
|000044f0| 72 69 6e 67 20 2d 20 74 | 68 65 20 66 69 6c 74 65 |ring - t|he filte|
|00004500| 72 20 73 74 72 69 6e 67 | 20 75 73 65 64 20 74 6f |r string| used to|
|00004510| 20 66 69 6c 74 65 72 20 | 74 68 65 20 52 65 63 6f | filter |the Reco|
|00004520| 72 64 73 65 74 2e 20 20 | 46 6f 72 20 65 78 61 6d |rdset. |For exam|
|00004530| 70 6c 65 3a 0d 0a 55 73 | 72 49 64 20 3d 20 31 32 |ple:..Us|rId = 12|
|00004540| 33 20 41 4e 44 20 53 75 | 62 6d 69 74 44 61 74 65 |3 AND Su|bmitDate|
|00004550| 20 3e 20 27 31 2f 31 2f | 31 39 39 38 27 0d 0a 0d | > '1/1/|1998'...|
|00004560| 0a 4e 6f 74 65 3a 20 53 | 69 6e 67 6c 65 20 71 75 |.Note: S|ingle qu|
|00004570| 6f 74 65 73 20 6e 65 65 | 64 20 74 6f 20 62 65 20 |otes nee|d to be |
|00004580| 72 65 70 65 61 74 65 64 | 20 74 6f 20 77 6f 72 6b |repeated| to work|
|00004590| 20 63 6f 72 72 65 63 74 | 79 2e 20 20 46 6f 72 20 | correct|y. For |
|000045a0| 65 78 61 6d 70 6c 65 3a | 0d 0a 43 6f 6d 70 61 6e |example:|..Compan|
|000045b0| 79 4e 61 6d 65 20 3d 20 | 27 4a 6f 68 6e 27 27 73 |yName = |'John''s|
|000045c0| 20 42 61 69 74 20 61 6e | 64 20 54 61 63 6b 6c 65 | Bait an|d Tackle|
|000045d0| 27 0d 0a 0d 0a 54 79 70 | 69 63 61 6c 20 50 61 72 |'....Typ|ical Par|
|000045e0| 74 69 63 69 70 61 6e 74 | 73 3a 0d 0a 5b 52 65 63 |ticipant|s:..[Rec|
|000045f0| 6f 72 64 73 65 74 5d 20 | 2d 20 61 20 52 65 63 6f |ordset] |- a Reco|
|00004600| 72 64 73 65 74 0d 0a 0d | 0a 53 65 65 20 44 61 74 |rdset...|.See Dat|
|00004610| 61 62 61 73 65 46 69 6c | 74 65 72 56 31 30 5f 33 |abaseFil|terV10_3|
|00004620| 30 2e 64 6f 63 20 66 6f | 72 20 67 65 6e 65 72 61 |0.doc fo|r genera|
|00004630| 6c 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 6f 6e |l inform|ation on|
|00004640| 20 44 61 74 61 62 61 73 | 65 20 46 69 6c 74 65 72 | Databas|e Filter|
|00004650| 20 63 6f 6e 74 72 61 63 | 74 73 2e 20 20 04 80 12 | contrac|ts. ...|
|00004660| 00 00 00 2f 46 69 6c 74 | 65 72 20 5b 74 61 72 67 |.../Filt|er [targ|
|00004670| 65 74 5d 20 20 77 68 65 | 6e 20 5b 73 6f 75 72 63 |et] whe|n [sourc|
|00004680| 65 5d 20 69 73 20 63 6c | 69 63 6b 65 64 20 28 44 |e] is cl|icked (D|
|00004690| 46 57 29 00 00 00 00 00 | 02 00 06 80 01 00 00 00 |FW).....|........|
|000046a0| 06 73 6f 75 72 63 65 01 | 00 08 80 03 00 00 00 00 |.source.|........|
|000046b0| 00 00 00 07 6f 6e 43 6c | 69 63 6b 01 00 10 80 04 |....onCl|ick.....|
|000046c0| 00 00 00 07 6f 6e 43 6c | 69 63 6b 01 00 00 00 00 |....onCl|ick.....|
|000046d0| 00 00 00 00 06 80 01 00 | 00 00 06 74 61 72 67 65 |........|...targe|
|000046e0| 74 03 00 08 80 03 00 00 | 00 01 00 00 00 0d 46 69 |t.......|......Fi|
|000046f0| 6c 74 65 72 28 77 68 65 | 72 65 29 08 80 03 00 00 |lter(whe|re).....|
|00004700| 00 00 00 00 00 08 53 65 | 72 76 65 72 28 29 08 80 |......Se|rver()..|
|00004710| 03 00 00 00 01 00 00 00 | 0a 4d 6f 76 65 4e 65 78 |........|.MoveNex|
|00004720| 74 28 29 01 00 10 80 04 | 00 00 00 08 53 65 72 76 |t().....|....Serv|
|00004730| 65 72 28 29 02 00 00 00 | 00 00 00 00 ff 3b 10 69 |er()....|.....;.i|
|00004740| 66 28 52 65 71 75 65 73 | 74 2e 46 6f 72 6d 2e 4b |f(Reques|t.Form.K|
|00004750| 65 79 28 22 5b 53 6f 75 | 72 63 65 5d 22 29 20 21 |ey("[Sou|rce]") !|
|00004760| 3d 20 22 22 29 20 0d 0a | 7b 0d 0a 09 76 61 72 20 |= "") ..|{...var |
|00004770| 57 68 65 72 65 20 3d 20 | 22 22 3b 0d 0a 09 76 61 |Where = |"";...va|
|00004780| 72 20 43 6f 6c 43 6f 75 | 6e 74 20 3d 20 30 3b 0d |r ColCou|nt = 0;.|
|00004790| 0a 09 6e 42 69 6e 64 69 | 6e 67 20 3d 20 30 3b 0d |..nBindi|ng = 0;.|
|000047a0| 0a 09 66 6f 72 28 3b 3b | 6e 42 69 6e 64 69 6e 67 |..for(;;|nBinding|
|000047b0| 2b 2b 29 0d 0a 09 7b 0d | 0a 09 09 42 6f 75 6e 64 |++)...{.|...Bound|
|000047c0| 43 6f 6c 75 6d 6e 20 3d | 20 5b 74 61 72 67 65 74 |Column =| [target|
|000047d0| 5d 2e 47 65 74 42 6f 75 | 6e 64 43 6f 6c 75 6d 6e |].GetBou|ndColumn|
|000047e0| 4e 61 6d 65 42 79 49 6e | 64 65 78 28 6e 42 69 6e |NameByIn|dex(nBin|
|000047f0| 64 69 6e 67 29 3b 0d 0a | 09 09 69 66 20 28 42 6f |ding);..|..if (Bo|
|00004800| 75 6e 64 43 6f 6c 75 6d | 6e 20 3d 3d 20 22 22 29 |undColum|n == "")|
|00004810| 0d 0a 09 09 7b 0d 0a 09 | 09 09 62 72 65 61 6b 3b |....{...|..break;|
|00004820| 0d 0a 09 09 7d 0d 0a 09 | 09 42 69 6e 64 69 6e 67 |....}...|.Binding|
|00004830| 54 79 70 65 20 3d 20 5b | 74 61 72 67 65 74 5d 2e |Type = [|target].|
|00004840| 47 65 74 42 69 6e 64 69 | 6e 67 54 79 70 65 28 42 |GetBindi|ngType(B|
|00004850| 6f 75 6e 64 43 6f 6c 75 | 6d 6e 29 3b 0d 0a 09 09 |oundColu|mn);....|
|00004860| 46 6f 72 6d 45 6c 65 6d | 65 6e 74 20 3d 20 6e 75 |FormElem|ent = nu|
|00004870| 6c 6c 3b 0d 0a 09 09 42 | 6f 75 6e 64 56 61 6c 75 |ll;....B|oundValu|
|00004880| 65 20 3d 20 5b 74 61 72 | 67 65 74 5d 2e 47 65 74 |e = [tar|get].Get|
|00004890| 42 69 6e 64 69 6e 67 56 | 61 6c 75 65 28 42 6f 75 |BindingV|alue(Bou|
|000048a0| 6e 64 43 6f 6c 75 6d 6e | 29 3b 0d 0a 0d 0a 09 09 |ndColumn|);......|
|000048b0| 44 6f 55 70 64 61 74 65 | 20 3d 20 74 72 75 65 3b |DoUpdate| = true;|
|000048c0| 0d 0a 09 09 69 66 28 42 | 69 6e 64 69 6e 67 54 79 |....if(B|indingTy|
|000048d0| 70 65 20 3d 3d 20 22 46 | 52 4d 22 29 20 2f 2f 20 |pe == "F|RM") // |
|000048e0| 66 6f 72 6d 20 65 6c 65 | 6d 65 6e 74 20 6e 61 6d |form ele|ment nam|
|000048f0| 65 0d 0a 09 09 7b 0d 0a | 09 09 09 46 6f 72 6d 45 |e....{..|...FormE|
|00004900| 6c 65 6d 65 6e 74 20 3d | 20 42 6f 75 6e 64 56 61 |lement =| BoundVa|
|00004910| 6c 75 65 3b 0d 0a 09 09 | 09 69 66 28 52 65 71 75 |lue;....|.if(Requ|
|00004920| 65 73 74 2e 46 6f 72 6d | 2e 4b 65 79 28 46 6f 72 |est.Form|.Key(For|
|00004930| 6d 45 6c 65 6d 65 6e 74 | 29 20 3d 3d 20 22 22 29 |mElement|) == "")|
|00004940| 0d 0a 09 09 09 7b 0d 0a | 09 09 09 09 42 6f 75 6e |.....{..|....Boun|
|00004950| 64 56 61 6c 75 65 20 3d | 20 22 22 3b 0d 0a 09 09 |dValue =| "";....|
|00004960| 09 7d 0d 0a 09 09 09 65 | 6c 73 65 0d 0a 09 09 09 |.}.....e|lse.....|
|00004970| 7b 0d 0a 09 09 09 09 42 | 6f 75 6e 64 56 61 6c 75 |{......B|oundValu|
|00004980| 65 20 3d 20 52 65 71 75 | 65 73 74 28 46 6f 72 6d |e = Requ|est(Form|
|00004990| 45 6c 65 6d 65 6e 74 29 | 3b 0d 0a 09 09 09 7d 0d |Element)|;.....}.|
|000049a0| 0a 09 09 7d 0d 0a 09 09 | 65 6c 73 65 20 69 66 28 |...}....|else if(|
|000049b0| 42 69 6e 64 69 6e 67 54 | 79 70 65 20 3d 3d 20 22 |BindingT|ype == "|
|000049c0| 56 41 52 22 29 20 2f 2f | 20 6a 61 76 61 73 63 72 |VAR") //| javascr|
|000049d0| 69 70 74 20 76 61 72 69 | 61 62 6c 65 0d 0a 09 09 |ipt vari|able....|
|000049e0| 7b 0d 0a 09 09 09 42 6f | 75 6e 64 56 61 6c 75 65 |{.....Bo|undValue|
|000049f0| 20 3d 20 65 76 61 6c 28 | 42 6f 75 6e 64 56 61 6c | = eval(|BoundVal|
|00004a00| 75 65 29 3b 0d 0a 09 09 | 7d 0d 0a 09 09 65 6c 73 |ue);....|}....els|
|00004a10| 65 20 69 66 28 42 69 6e | 64 69 6e 67 54 79 70 65 |e if(Bin|dingType|
|00004a20| 20 21 3d 20 22 56 41 4c | 22 29 20 2f 2f 20 6c 69 | != "VAL|") // li|
|00004a30| 74 65 72 61 6c 20 76 61 | 6c 75 65 0d 0a 09 09 7b |teral va|lue....{|
|00004a40| 0d 0a 09 09 09 44 6f 55 | 70 64 61 74 65 20 3d 20 |.....DoU|pdate = |
|00004a50| 66 61 6c 73 65 3b 0d 0a | 09 09 7d 0d 0a 0d 0a 09 |false;..|..}.....|
|00004a60| 09 42 6f 75 6e 64 56 61 | 6c 75 65 20 3d 20 52 65 |.BoundVa|lue = Re|
|00004a70| 70 6c 61 63 65 53 69 6e | 67 6c 65 51 75 6f 74 65 |placeSin|gleQuote|
|00004a80| 57 69 74 68 54 77 6f 28 | 42 6f 75 6e 64 56 61 6c |WithTwo(|BoundVal|
|00004a90| 75 65 29 3b 0d 0a 0d 0a | 09 09 76 61 72 20 46 69 |ue);....|..var Fi|
|00004aa0| 65 6c 64 20 3d 20 5b 74 | 61 72 67 65 74 5d 2e 47 |eld = [t|arget].G|
|00004ab0| 65 74 46 69 65 6c 64 28 | 42 6f 75 6e 64 43 6f 6c |etField(|BoundCol|
|00004ac0| 75 6d 6e 29 3b 0d 0a 09 | 09 76 61 72 20 43 6f 6c |umn);...|.var Col|
|00004ad0| 54 79 70 65 20 3d 20 2d | 31 3b 0d 0a 09 09 69 66 |Type = -|1;....if|
|00004ae0| 28 46 69 65 6c 64 20 21 | 3d 20 6e 75 6c 6c 29 0d |(Field !|= null).|
|00004af0| 0a 09 09 7b 0d 0a 09 09 | 09 43 6f 6c 54 79 70 65 |...{....|.ColType|
|00004b00| 20 3d 20 46 69 65 6c 64 | 2e 54 79 70 65 3b 0d 0a | = Field|.Type;..|
|00004b10| 09 09 7d 0d 0a 0d 0a 09 | 09 2f 2f 20 70 75 74 20 |..}.....|.// put |
|00004b20| 62 72 61 63 6b 65 74 73 | 20 6f 6e 20 62 6f 75 6e |brackets| on boun|
|00004b30| 64 20 63 6f 6c 75 6d 6e | 20 6e 61 6d 65 20 69 66 |d column| name if|
|00004b40| 20 6e 65 63 65 73 73 61 | 72 79 0d 0a 09 09 69 66 | necessa|ry....if|
|00004b50| 28 28 42 6f 75 6e 64 43 | 6f 6c 75 6d 6e 2e 69 6e |((BoundC|olumn.in|
|00004b60| 64 65 78 4f 66 28 22 20 | 22 29 20 21 3d 20 2d 31 |dexOf(" |") != -1|
|00004b70| 29 20 26 26 20 42 6f 75 | 6e 64 43 6f 6c 75 6d 6e |) && Bou|ndColumn|
|00004b80| 2e 63 68 61 72 41 74 28 | 42 6f 75 6e 64 43 6f 6c |.charAt(|BoundCol|
|00004b90| 75 6d 6e 2e 6c 65 6e 67 | 74 68 20 2d 20 31 29 20 |umn.leng|th - 1) |
|00004ba0| 21 3d 20 22 5d 22 29 0d | 0a 09 09 7b 0d 0a 09 09 |!= "]").|...{....|
|00004bb0| 09 2f 2f 20 63 68 65 63 | 6b 20 66 6f 72 20 74 61 |.// chec|k for ta|
|00004bc0| 62 6c 65 6e 61 6d 65 2e | 63 6f 6c 75 6d 6e 0d 0a |blename.|column..|
|00004bd0| 09 09 09 6e 44 6f 74 20 | 3d 20 42 6f 75 6e 64 43 |...nDot |= BoundC|
|00004be0| 6f 6c 75 6d 6e 2e 69 6e | 64 65 78 4f 66 28 22 2e |olumn.in|dexOf(".|
|00004bf0| 22 29 3b 0d 0a 09 09 09 | 69 66 28 6e 44 6f 74 20 |");.....|if(nDot |
|00004c00| 3e 3d 20 30 29 0d 0a 09 | 09 09 7b 0d 0a 09 09 09 |>= 0)...|..{.....|
|00004c10| 09 54 68 65 54 61 62 6c | 65 4e 61 6d 65 20 3d 20 |.TheTabl|eName = |
|00004c20| 42 6f 75 6e 64 43 6f 6c | 75 6d 6e 2e 73 75 62 73 |BoundCol|umn.subs|
|00004c30| 74 72 69 6e 67 28 30 2c | 20 6e 44 6f 74 29 3b 0d |tring(0,| nDot);.|
|00004c40| 0a 09 09 09 09 54 68 65 | 43 6f 6c 75 6d 6e 4e 61 |.....The|ColumnNa|
|00004c50| 6d 65 20 3d 20 42 6f 75 | 6e 64 43 6f 6c 75 6d 6e |me = Bou|ndColumn|
|00004c60| 2e 73 75 62 73 74 72 69 | 6e 67 28 6e 44 6f 74 20 |.substri|ng(nDot |
|00004c70| 2b 20 31 2c 20 42 6f 75 | 6e 64 43 6f 6c 75 6d 6e |+ 1, Bou|ndColumn|
|00004c80| 2e 6c 65 6e 67 74 68 29 | 3b 0d 0a 09 09 09 09 69 |.length)|;......i|
|00004c90| 66 28 54 68 65 54 61 62 | 6c 65 4e 61 6d 65 2e 69 |f(TheTab|leName.i|
|00004ca0| 6e 64 65 78 4f 66 28 22 | 20 22 29 20 26 26 20 54 |ndexOf("| ") && T|
|00004cb0| 68 65 54 61 62 6c 65 4e | 61 6d 65 2e 63 68 61 72 |heTableN|ame.char|
|00004cc0| 41 74 28 54 68 65 54 61 | 62 6c 65 4e 61 6d 65 2e |At(TheTa|bleName.|
|00004cd0| 6c 65 6e 67 74 68 20 2d | 20 31 29 20 21 3d 20 22 |length -| 1) != "|
|00004ce0| 5d 22 29 0d 0a 09 09 09 | 09 7b 0d 0a 09 09 09 09 |]").....|.{......|
|00004cf0| 09 2f 2f 20 70 75 74 20 | 62 72 61 63 6b 65 74 73 |.// put |brackets|
|00004d00| 20 6f 6e 20 74 61 62 6c | 65 20 6e 61 6d 65 0d 0a | on tabl|e name..|
|00004d10| 09 09 09 09 09 54 68 65 | 54 61 62 6c 65 4e 61 6d |.....The|TableNam|
|00004d20| 65 20 3d 20 22 5b 22 20 | 2b 20 54 68 65 54 61 62 |e = "[" |+ TheTab|
|00004d30| 6c 65 6e 61 6d 65 20 2b | 20 22 5d 22 3b 0d 0a 09 |lename +| "]";...|
|00004d40| 09 09 09 7d 0d 0a 09 09 | 09 09 69 66 28 54 68 65 |...}....|..if(The|
|00004d50| 43 6f 6c 75 6d 6e 4e 61 | 6d 65 2e 69 6e 64 65 78 |ColumnNa|me.index|
|00004d60| 4f 66 28 22 20 22 29 29 | 0d 0a 09 09 09 09 7b 0d |Of(" "))|......{.|
|00004d70| 0a 09 09 09 09 09 2f 2f | 20 70 75 74 20 62 72 61 |......//| put bra|
|00004d80| 63 6b 65 74 73 20 6f 6e | 20 63 6f 6c 75 6d 6e 20 |ckets on| column |
|00004d90| 6e 61 6d 65 0d 0a 09 09 | 09 09 09 54 68 65 43 6f |name....|...TheCo|
|00004da0| 6c 75 6d 6e 4e 61 6d 65 | 20 3d 20 22 5b 22 20 2b |lumnName| = "[" +|
|00004db0| 20 54 68 65 43 6f 6c 75 | 6d 6e 4e 61 6d 65 20 2b | TheColu|mnName +|
|00004dc0| 20 22 5d 22 3b 0d 0a 09 | 09 09 09 7d 0d 0a 09 09 | "]";...|...}....|
|00004dd0| 09 09 42 6f 75 6e 64 43 | 6f 6c 75 6d 6e 20 3d 20 |..BoundC|olumn = |
|00004de0| 54 68 65 54 61 62 6c 65 | 4e 61 6d 65 20 2b 20 22 |TheTable|Name + "|
|00004df0| 2e 22 20 2b 20 54 68 65 | 43 6f 6c 75 6d 6e 4e 61 |." + The|ColumnNa|
|00004e00| 6d 65 3b 0d 0a 09 09 09 | 7d 0d 0a 09 09 09 65 6c |me;.....|}.....el|
|00004e10| 73 65 0d 0a 09 09 09 7b | 0d 0a 09 09 09 09 42 6f |se.....{|......Bo|
|00004e20| 75 6e 64 43 6f 6c 75 6d | 6e 20 3d 20 22 5b 22 20 |undColum|n = "[" |
|00004e30| 2b 20 42 6f 75 6e 64 43 | 6f 6c 75 6d 6e 20 2b 20 |+ BoundC|olumn + |
|00004e40| 22 5d 22 3b 0d 0a 09 09 | 09 7d 0d 0a 09 09 7d 0d |"]";....|.}....}.|
|00004e50| 0a 0d 0a 09 09 76 61 72 | 20 43 6f 6d 70 61 72 69 |.....var| Compari|
|00004e60| 73 69 6f 6e 4f 70 20 3d | 20 22 22 20 2b 20 5b 63 |sionOp =| "" + [c|
|00004e70| 6f 6d 70 61 72 69 73 69 | 6f 6e 4f 70 5d 20 2b 20 |omparisi|onOp] + |
|00004e80| 22 22 3b 0d 0a 0d 0a 09 | 09 69 66 28 28 28 22 22 |"";.....|.if(((""|
|00004e90| 20 2b 20 42 6f 75 6e 64 | 56 61 6c 75 65 29 20 3d | + Bound|Value) =|
|00004ea0| 3d 20 22 22 29 29 0d 0a | 09 09 7b 0d 0a 09 09 7d |= ""))..|..{....}|
|00004eb0| 0d 0a 09 09 65 6c 73 65 | 20 69 66 28 28 52 65 71 |....else| if((Req|
|00004ec0| 75 65 73 74 2e 46 6f 72 | 6d 2e 4b 65 79 28 46 6f |uest.For|m.Key(Fo|
|00004ed0| 72 6d 45 6c 65 6d 65 6e | 74 29 20 3d 3d 20 22 22 |rmElemen|t) == ""|
|00004ee0| 2f 2a 74 6f 20 68 61 6e | 64 6c 65 20 74 68 65 20 |/*to han|dle the |
|00004ef0| 75 6e 63 68 65 63 6b 65 | 64 20 73 74 61 74 65 20 |unchecke|d state |
|00004f00| 66 6f 72 20 63 68 65 63 | 6b 62 6f 78 20 63 6f 6e |for chec|kbox con|
|00004f10| 74 72 6f 6c 2a 2f 29 20 | 26 26 20 42 69 6e 64 69 |trol*/) |&& Bindi|
|00004f20| 6e 67 54 79 70 65 20 3d | 3d 20 22 46 52 4d 22 29 |ngType =|= "FRM")|
|00004f30| 0d 0a 09 09 7b 0d 0a 09 | 09 09 2f 2f 20 63 6f 6e |....{...|..// con|
|00004f40| 66 69 72 6d 20 64 61 74 | 61 54 79 70 65 20 69 73 |firm dat|aType is|
|00004f50| 20 62 6f 6f 6c 65 61 6e | 0d 0a 09 09 09 69 66 20 | boolean|.....if |
|00004f60| 28 43 6f 6c 54 79 70 65 | 20 3d 3d 20 31 31 2f 2a |(ColType| == 11/*|
|00004f70| 61 64 42 6f 6f 6c 65 61 | 6e 20 3d 20 31 31 2a 2f |adBoolea|n = 11*/|
|00004f80| 29 0d 0a 09 09 09 7b 0d | 0a 09 09 09 09 69 66 20 |).....{.|.....if |
|00004f90| 28 43 6f 6c 43 6f 75 6e | 74 20 21 3d 20 30 29 0d |(ColCoun|t != 0).|
|00004fa0| 0a 09 09 09 09 7b 0d 0a | 09 09 09 09 09 57 68 65 |.....{..|.....Whe|
|00004fb0| 72 65 20 3d 20 57 68 65 | 72 65 20 2b 20 22 20 22 |re = Whe|re + " "|
|00004fc0| 20 2b 20 5b 4c 6f 67 69 | 63 61 6c 4f 70 65 72 61 | + [Logi|calOpera|
|00004fd0| 74 6f 72 5d 20 2b 20 22 | 20 22 3b 0d 0a 09 09 09 |tor] + "| ";.....|
|00004fe0| 09 7d 0d 0a 09 09 09 09 | 57 68 65 72 65 20 3d 20 |.}......|Where = |
|00004ff0| 57 68 65 72 65 20 2b 20 | 22 28 22 20 2b 20 42 6f |Where + |"(" + Bo|
|00005000| 75 6e 64 43 6f 6c 75 6d | 6e 20 2b 20 22 20 3d 20 |undColum|n + " = |
|00005010| 30 29 22 3b 0d 0a 09 09 | 09 09 43 6f 6c 43 6f 75 |0)";....|..ColCou|
|00005020| 6e 74 20 3d 20 43 6f 6c | 43 6f 75 6e 74 20 2b 20 |nt = Col|Count + |
|00005030| 31 3b 0d 0a 09 09 09 7d | 0d 0a 09 09 7d 0d 0a 09 |1;.....}|....}...|
|00005040| 09 65 6c 73 65 0d 0a 09 | 09 7b 0d 0a 09 09 09 69 |.else...|.{.....i|
|00005050| 66 28 43 6f 6c 43 6f 75 | 6e 74 20 21 3d 20 30 29 |f(ColCou|nt != 0)|
|00005060| 0d 0a 09 09 09 7b 0d 0a | 09 09 09 09 57 68 65 72 |.....{..|....Wher|
|00005070| 65 20 3d 20 57 68 65 72 | 65 20 2b 20 22 20 22 20 |e = Wher|e + " " |
|00005080| 2b 20 5b 4c 6f 67 69 63 | 61 6c 4f 70 65 72 61 74 |+ [Logic|alOperat|
|00005090| 6f 72 5d 20 2b 20 22 20 | 22 3b 0d 0a 09 09 09 7d |or] + " |";.....}|
|000050a0| 0d 0a 09 09 09 73 77 69 | 74 63 68 28 43 6f 6c 54 |.....swi|tch(ColT|
|000050b0| 79 70 65 29 0d 0a 09 09 | 09 7b 0d 0a 09 09 09 09 |ype)....|.{......|
|000050c0| 63 61 73 65 20 37 3a 09 | 09 2f 2a 61 64 44 61 74 |case 7:.|./*adDat|
|000050d0| 65 2a 2f 0d 0a 09 09 09 | 09 63 61 73 65 20 31 33 |e*/.....|.case 13|
|000050e0| 33 3a 09 2f 2a 61 64 44 | 42 44 61 74 65 2a 2f 0d |3:./*adD|BDate*/.|
|000050f0| 0a 09 09 09 09 63 61 73 | 65 20 31 33 34 3a 09 2f |.....cas|e 134:./|
|00005100| 2a 61 64 44 42 54 69 6d | 65 2a 2f 0d 0a 09 09 09 |*adDBTim|e*/.....|
|00005110| 09 63 61 73 65 20 31 33 | 35 3a 09 2f 2a 61 64 44 |.case 13|5:./*adD|
|00005120| 42 54 69 6d 65 53 74 61 | 6d 70 2a 2f 0d 0a 09 09 |BTimeSta|mp*/....|
|00005130| 09 09 09 7b 0d 0a 09 09 | 09 09 09 09 69 66 20 28 |...{....|....if (|
|00005140| 43 6f 6d 70 61 72 69 73 | 69 6f 6e 4f 70 20 3d 3d |Comparis|ionOp ==|
|00005150| 20 22 62 65 67 69 6e 73 | 20 77 69 74 68 22 29 0d | "begins| with").|
|00005160| 0a 09 09 09 09 09 09 7b | 0d 0a 09 09 09 09 09 09 |.......{|........|
|00005170| 09 57 68 65 72 65 20 3d | 20 57 68 65 72 65 20 2b |.Where =| Where +|
|00005180| 20 22 28 22 20 2b 20 42 | 6f 75 6e 64 43 6f 6c 75 | "(" + B|oundColu|
|00005190| 6d 6e 20 2b 20 22 20 4c | 49 4b 45 20 23 22 20 2b |mn + " L|IKE #" +|
|000051a0| 20 42 6f 75 6e 64 56 61 | 6c 75 65 20 2b 20 20 22 | BoundVa|lue + "|
|000051b0| 2a 23 29 22 3b 0d 0a 09 | 09 09 09 09 09 7d 0d 0a |*#)";...|.....}..|
|000051c0| 09 09 09 09 09 09 65 6c | 73 65 20 69 66 28 43 6f |......el|se if(Co|
|000051d0| 6d 70 61 72 69 73 69 6f | 6e 4f 70 20 3d 3d 20 22 |mparisio|nOp == "|
|000051e0| 63 6f 6e 74 61 69 6e 73 | 22 29 0d 0a 09 09 09 09 |contains|")......|
|000051f0| 09 09 7b 0d 0a 09 09 09 | 09 09 09 09 57 68 65 72 |..{.....|....Wher|
|00005200| 65 20 3d 20 57 68 65 72 | 65 20 2b 20 22 28 22 20 |e = Wher|e + "(" |
|00005210| 2b 20 42 6f 75 6e 64 43 | 6f 6c 75 6d 6e 20 2b 20 |+ BoundC|olumn + |
|00005220| 22 20 4c 49 4b 45 20 23 | 25 22 20 2b 20 42 6f 75 |" LIKE #|%" + Bou|
|00005230| 6e 64 56 61 6c 75 65 20 | 2b 20 20 22 25 23 29 22 |ndValue |+ "%#)"|
|00005240| 3b 0d 0a 09 09 09 09 09 | 09 7d 0d 0a 09 09 09 09 |;.......|.}......|
|00005250| 09 09 65 6c 73 65 20 69 | 66 28 43 6f 6d 70 61 72 |..else i|f(Compar|
|00005260| 69 73 69 6f 6e 4f 70 20 | 3d 3d 20 22 65 6e 64 73 |isionOp |== "ends|
|00005270| 20 77 69 74 68 22 29 20 | 0d 0a 09 09 09 09 09 09 | with") |........|
|00005280| 7b 0d 0a 09 09 09 09 09 | 09 09 57 68 65 72 65 20 |{.......|..Where |
|00005290| 3d 20 57 68 65 72 65 20 | 2b 20 22 28 22 20 2b 20 |= Where |+ "(" + |
|000052a0| 42 6f 75 6e 64 43 6f 6c | 75 6d 6e 20 2b 20 22 20 |BoundCol|umn + " |
|000052b0| 4c 49 4b 45 20 23 25 22 | 20 2b 20 42 6f 75 6e 64 |LIKE #%"| + Bound|
|000052c0| 56 61 6c 75 65 20 2b 20 | 20 22 23 29 22 3b 0d 0a |Value + | "#)";..|
|000052d0| 09 09 09 09 09 09 7d 0d | 0a 09 09 09 09 09 09 65 |......}.|.......e|
|000052e0| 6c 73 65 20 69 66 28 43 | 6f 6d 70 61 72 69 73 69 |lse if(C|omparisi|
|000052f0| 6f 6e 4f 70 20 3d 3d 20 | 22 65 71 75 61 6c 20 74 |onOp == |"equal t|
|00005300| 6f 22 29 20 0d 0a 09 09 | 09 09 09 09 7b 0d 0a 09 |o") ....|....{...|
|00005310| 09 09 09 09 09 09 57 68 | 65 72 65 20 3d 20 57 68 |......Wh|ere = Wh|
|00005320| 65 72 65 20 2b 20 22 28 | 22 20 2b 20 42 6f 75 6e |ere + "(|" + Boun|
|00005330| 64 43 6f 6c 75 6d 6e 20 | 2b 20 22 20 3d 20 23 22 |dColumn |+ " = #"|
|00005340| 20 2b 20 42 6f 75 6e 64 | 56 61 6c 75 65 20 2b 20 | + Bound|Value + |
|00005350| 20 22 23 29 22 3b 0d 0a | 09 09 09 09 09 09 7d 0d | "#)";..|......}.|
|00005360| 0a 09 09 09 09 09 09 65 | 6c 73 65 0d 0a 09 09 09 |.......e|lse.....|
|00005370| 09 09 09 7b 0d 0a 09 09 | 09 09 09 09 09 57 68 65 |...{....|.....Whe|
|00005380| 72 65 20 3d 20 57 68 65 | 72 65 20 2b 20 22 28 22 |re = Whe|re + "("|
|00005390| 20 2b 20 42 6f 75 6e 64 | 43 6f 6c 75 6d 6e 20 2b | + Bound|Column +|
|000053a0| 20 22 20 4c 49 4b 45 20 | 23 22 20 2b 20 42 6f 75 | " LIKE |#" + Bou|
|000053b0| 6e 64 56 61 6c 75 65 20 | 2b 20 20 22 2a 23 29 22 |ndValue |+ "*#)"|
|000053c0| 3b 0d 0a 09 09 09 09 09 | 09 7d 0d 0a 09 09 09 09 |;.......|.}......|
|000053d0| 09 7d 0d 0a 09 09 09 09 | 64 65 66 61 75 6c 74 3a |.}......|default:|
|000053e0| 0d 0a 09 09 09 09 09 7b | 0d 0a 09 09 09 09 09 09 |.......{|........|
|000053f0| 69 66 20 28 43 6f 6d 70 | 61 72 69 73 69 6f 6e 4f |if (Comp|arisionO|
|00005400| 70 20 3d 3d 20 22 62 65 | 67 69 6e 73 20 77 69 74 |p == "be|gins wit|
|00005410| 68 22 29 0d 0a 09 09 09 | 09 09 09 7b 0d 0a 09 09 |h").....|...{....|
|00005420| 09 09 09 09 09 57 68 65 | 72 65 20 20 3d 20 57 68 |.....Whe|re = Wh|
|00005430| 65 72 65 20 20 2b 20 22 | 28 22 20 2b 20 42 6f 75 |ere + "|(" + Bou|
|00005440| 6e 64 43 6f 6c 75 6d 6e | 20 2b 20 22 20 4c 49 4b |ndColumn| + " LIK|
|00005450| 45 20 27 22 20 2b 20 42 | 6f 75 6e 64 56 61 6c 75 |E '" + B|oundValu|
|00005460| 65 20 2b 20 20 22 2a 27 | 29 22 3b 0d 0a 09 09 09 |e + "*'|)";.....|
|00005470| 09 09 09 7d 0d 0a 09 09 | 09 09 09 09 65 6c 73 65 |...}....|....else|
|00005480| 20 69 66 28 43 6f 6d 70 | 61 72 69 73 69 6f 6e 4f | if(Comp|arisionO|
|00005490| 70 20 3d 3d 20 22 63 6f | 6e 74 61 69 6e 73 22 29 |p == "co|ntains")|
|000054a0| 0d 0a 09 09 09 09 09 09 | 7b 0d 0a 09 09 09 09 09 |........|{.......|
|000054b0| 09 09 57 68 65 72 65 20 | 20 3d 20 57 68 65 72 65 |..Where | = Where|
|000054c0| 20 2b 20 22 28 22 20 2b | 20 42 6f 75 6e 64 43 6f | + "(" +| BoundCo|
|000054d0| 6c 75 6d 6e 20 2b 20 22 | 20 4c 49 4b 45 20 27 25 |lumn + "| LIKE '%|
|000054e0| 22 20 2b 20 42 6f 75 6e | 64 56 61 6c 75 65 20 2b |" + Boun|dValue +|
|000054f0| 20 20 22 25 27 29 22 3b | 0d 0a 09 09 09 09 09 09 | "%')";|........|
|00005500| 7d 0d 0a 09 09 09 09 09 | 09 65 6c 73 65 20 69 66 |}.......|.else if|
|00005510| 28 43 6f 6d 70 61 72 69 | 73 69 6f 6e 4f 70 20 3d |(Compari|sionOp =|
|00005520| 3d 20 22 65 6e 64 73 20 | 77 69 74 68 22 29 20 0d |= "ends |with") .|
|00005530| 0a 09 09 09 09 09 09 7b | 0d 0a 09 09 09 09 09 09 |.......{|........|
|00005540| 09 57 68 65 72 65 20 20 | 3d 20 57 68 65 72 65 20 |.Where |= Where |
|00005550| 20 2b 20 22 28 22 20 2b | 20 42 6f 75 6e 64 43 6f | + "(" +| BoundCo|
|00005560| 6c 75 6d 6e 20 2b 20 22 | 20 4c 49 4b 45 20 27 25 |lumn + "| LIKE '%|
|00005570| 22 20 2b 20 42 6f 75 6e | 64 56 61 6c 75 65 20 2b |" + Boun|dValue +|
|00005580| 20 20 22 27 29 22 3b 0d | 0a 09 09 09 09 09 09 7d | "')";.|.......}|
|00005590| 0d 0a 09 09 09 09 09 09 | 65 6c 73 65 20 69 66 28 |........|else if(|
|000055a0| 43 6f 6d 70 61 72 69 73 | 69 6f 6e 4f 70 20 3d 3d |Comparis|ionOp ==|
|000055b0| 20 22 65 71 75 61 6c 20 | 74 6f 22 29 20 0d 0a 09 | "equal |to") ...|
|000055c0| 09 09 09 09 09 7b 0d 0a | 09 09 09 09 09 09 09 57 |.....{..|.......W|
|000055d0| 68 65 72 65 20 20 3d 20 | 57 68 65 72 65 20 2b 20 |here = |Where + |
|000055e0| 22 28 22 20 2b 20 42 6f | 75 6e 64 43 6f 6c 75 6d |"(" + Bo|undColum|
|000055f0| 6e 20 2b 20 22 20 3d 27 | 22 20 2b 20 42 6f 75 6e |n + " ='|" + Boun|
|00005600| 64 56 61 6c 75 65 20 2b | 20 20 22 27 29 22 3b 0d |dValue +| "')";.|
|00005610| 0a 09 09 09 09 09 09 7d | 0d 0a 09 09 09 09 09 09 |.......}|........|
|00005620| 65 6c 73 65 0d 0a 09 09 | 09 09 09 09 7b 0d 0a 09 |else....|....{...|
|00005630| 09 09 09 09 09 09 57 68 | 65 72 65 20 20 3d 20 57 |......Wh|ere = W|
|00005640| 68 65 72 65 20 20 2b 20 | 22 28 22 20 2b 20 43 6f |here + |"(" + Co|
|00005650| 6c 75 6d 6e 4e 61 6d 65 | 20 2b 20 22 20 4c 49 4b |lumnName| + " LIK|
|00005660| 45 20 27 22 20 2b 20 42 | 6f 75 6e 64 56 61 6c 75 |E '" + B|oundValu|
|00005670| 65 20 2b 20 20 22 2a 27 | 29 22 3b 0d 0a 09 09 09 |e + "*'|)";.....|
|00005680| 09 09 09 7d 0d 0a 09 09 | 09 09 09 7d 0d 0a 09 09 |...}....|...}....|
|00005690| 09 7d 0d 0a 09 09 09 43 | 6f 6c 43 6f 75 6e 74 20 |.}.....C|olCount |
|000056a0| 3d 20 43 6f 6c 43 6f 75 | 6e 74 20 2b 20 31 3b 0d |= ColCou|nt + 1;.|
|000056b0| 0a 09 09 7d 0d 0a 09 7d | 0d 0a 09 76 61 72 20 54 |...}...}|...var T|
|000056c0| 61 72 67 65 74 41 63 74 | 69 6f 6e 20 3d 20 22 46 |argetAct|ion = "F|
|000056d0| 69 6c 74 65 72 28 22 20 | 2b 20 22 22 20 2b 20 22 |ilter(" |+ "" + "|
|000056e0| 5c 22 22 20 2b 20 57 68 | 65 72 65 20 2b 20 22 5c |\"" + Wh|ere + "\|
|000056f0| 22 29 22 3b 20 0d 0a 09 | 54 61 72 67 65 74 41 63 |")"; ...|TargetAc|
|00005700| 74 69 6f 6e 20 3d 20 22 | 5b 74 61 72 67 65 74 5d |tion = "|[target]|
|00005710| 5f 41 63 74 69 6f 6e 3d | 22 20 2b 20 53 65 72 76 |_Action=|" + Serv|
|00005720| 65 72 2e 55 52 4c 45 6e | 63 6f 64 65 28 54 61 72 |er.URLEn|code(Tar|
|00005730| 67 65 74 41 63 74 69 6f | 6e 29 3b 0d 0a 09 52 65 |getActio|n);...Re|
|00005740| 73 70 6f 6e 73 65 2e 52 | 65 64 69 72 65 63 74 28 |sponse.R|edirect(|
|00005750| 65 73 63 61 70 65 28 5b | 6d 61 73 74 65 72 70 61 |escape([|masterpa|
|00005760| 67 65 5d 29 2b 22 3f 22 | 2b 54 61 72 67 65 74 41 |ge])+"?"|+TargetA|
|00005770| 63 74 69 6f 6e 29 3b 0d | 0a 7d 01 00 00 00 ff fc |ction);.|.}......|
|00005780| 0f 69 66 20 52 65 71 75 | 65 73 74 2e 46 6f 72 6d |.if Requ|est.Form|
|00005790| 2e 4b 65 79 28 22 5b 53 | 6f 75 72 63 65 5d 22 29 |.Key("[S|ource]")|
|000057a0| 20 3c 3e 22 22 20 74 68 | 65 6e 0d 0a 0d 0a 09 57 | <>"" th|en.....W|
|000057b0| 68 65 72 65 20 3d 20 22 | 22 0d 0a 09 43 6f 6c 43 |here = "|"...ColC|
|000057c0| 6f 75 6e 74 20 3d 20 30 | 0d 0a 09 6e 42 69 6e 64 |ount = 0|...nBind|
|000057d0| 69 6e 67 20 3d 20 30 0d | 0a 0d 0a 0d 0a 09 44 6f |ing = 0.|......Do|
|000057e0| 20 0d 0a 09 09 42 6f 75 | 6e 64 43 6f 6c 75 6d 6e | ....Bou|ndColumn|
|000057f0| 20 3d 20 20 5b 74 61 72 | 67 65 74 5d 2e 47 65 74 | = [tar|get].Get|
|00005800| 42 6f 75 6e 64 43 6f 6c | 75 6d 6e 4e 61 6d 65 42 |BoundCol|umnNameB|
|00005810| 79 49 6e 64 65 78 28 6e | 42 69 6e 64 69 6e 67 29 |yIndex(n|Binding)|
|00005820| 0d 0a 09 09 69 66 20 28 | 42 6f 75 6e 64 43 6f 6c |....if (|BoundCol|
|00005830| 75 6d 6e 20 3d 20 22 22 | 29 20 74 68 65 6e 0d 0a |umn = ""|) then..|
|00005840| 09 09 09 45 78 69 74 20 | 44 6f 0d 0a 09 09 65 6e |...Exit |Do....en|
|00005850| 64 20 69 66 0d 0a 09 09 | 42 69 6e 64 69 6e 67 54 |d if....|BindingT|
|00005860| 79 70 65 20 3d 20 20 5b | 74 61 72 67 65 74 5d 2e |ype = [|target].|
|00005870| 47 65 74 42 69 6e 64 69 | 6e 67 54 79 70 65 28 42 |GetBindi|ngType(B|
|00005880| 6f 75 6e 64 43 6f 6c 75 | 6d 6e 29 0d 0a 09 09 46 |oundColu|mn)....F|
|00005890| 6f 72 6d 45 6c 65 6d 65 | 6e 74 20 3d 20 6e 75 6c |ormEleme|nt = nul|
|000058a0| 6c 0d 0a 09 09 42 6f 75 | 6e 64 56 61 6c 75 65 20 |l....Bou|ndValue |
|000058b0| 3d 20 5b 74 61 72 67 65 | 74 5d 2e 47 65 74 42 69 |= [targe|t].GetBi|
|000058c0| 6e 64 69 6e 67 56 61 6c | 75 65 28 42 6f 75 6e 64 |ndingVal|ue(Bound|
|000058d0| 43 6f 6c 75 6d 6e 29 0d | 0a 09 09 44 6f 55 70 64 |Column).|...DoUpd|
|000058e0| 61 74 65 20 3d 20 74 72 | 75 65 0d 0a 0d 0a 09 09 |ate = tr|ue......|
|000058f0| 69 66 28 42 69 6e 64 69 | 6e 67 54 79 70 65 20 3d |if(Bindi|ngType =|
|00005900| 20 22 46 52 4d 22 29 20 | 20 74 68 65 6e 0d 0a 09 | "FRM") | then...|
|00005910| 09 09 52 45 4d 20 66 6f | 72 6d 20 65 6c 65 6d 65 |..REM fo|rm eleme|
|00005920| 6e 74 20 6e 61 6d 65 0d | 0a 09 09 09 46 6f 72 6d |nt name.|....Form|
|00005930| 45 6c 65 6d 65 6e 74 20 | 3d 20 42 6f 75 6e 64 56 |Element |= BoundV|
|00005940| 61 6c 75 65 0d 0a 09 09 | 09 69 66 28 52 65 71 75 |alue....|.if(Requ|
|00005950| 65 73 74 2e 46 6f 72 6d | 2e 4b 65 79 28 46 6f 72 |est.Form|.Key(For|
|00005960| 6d 45 6c 65 6d 65 6e 74 | 29 20 3d 20 22 22 29 20 |mElement|) = "") |
|00005970| 74 68 65 6e 0d 0a 09 09 | 09 09 42 6f 75 6e 64 56 |then....|..BoundV|
|00005980| 61 6c 75 65 20 3d 20 22 | 22 0d 0a 09 09 09 65 6c |alue = "|".....el|
|00005990| 73 65 0d 0a 09 09 09 09 | 42 6f 75 6e 64 56 61 6c |se......|BoundVal|
|000059a0| 75 65 20 3d 20 52 65 71 | 75 65 73 74 28 46 6f 72 |ue = Req|uest(For|
|000059b0| 6d 45 6c 65 6d 65 6e 74 | 29 0d 0a 09 09 09 65 6e |mElement|).....en|
|000059c0| 64 20 69 66 09 0d 0a 09 | 09 65 6c 73 65 69 66 20 |d if....|.elseif |
|000059d0| 28 42 69 6e 64 69 6e 67 | 54 79 70 65 20 3d 20 22 |(Binding|Type = "|
|000059e0| 56 41 52 22 29 20 74 68 | 65 6e 0d 0a 09 09 09 52 |VAR") th|en.....R|
|000059f0| 45 4d 20 6a 61 76 61 73 | 63 72 69 70 74 20 76 61 |EM javas|cript va|
|00005a00| 72 69 61 62 6c 65 0d 0a | 09 09 09 42 6f 75 6e 64 |riable..|...Bound|
|00005a10| 56 61 6c 75 65 20 3d 20 | 65 76 61 6c 28 42 6f 75 |Value = |eval(Bou|
|00005a20| 6e 64 56 61 6c 75 65 29 | 0d 0a 09 09 65 6c 73 65 |ndValue)|....else|
|00005a30| 69 66 20 28 42 69 6e 64 | 69 6e 67 54 79 70 65 20 |if (Bind|ingType |
|00005a40| 3c 3e 20 22 56 41 4c 22 | 29 20 20 74 68 65 6e 0d |<> "VAL"|) then.|
|00005a50| 0a 09 09 09 52 45 4d 20 | 6a 61 76 61 73 63 72 69 |....REM |javascri|
|00005a60| 70 74 20 76 61 72 69 61 | 62 6c 65 0d 0a 09 09 09 |pt varia|ble.....|
|00005a70| 44 6f 55 70 64 61 74 65 | 20 3d 20 66 61 6c 73 65 |DoUpdate| = false|
|00005a80| 0d 0a 09 09 65 6e 64 20 | 69 66 0d 0a 0d 0a 09 09 |....end |if......|
|00005a90| 42 6f 75 6e 64 56 61 6c | 75 65 20 3d 20 52 65 70 |BoundVal|ue = Rep|
|00005aa0| 6c 61 63 65 53 69 6e 67 | 6c 65 51 75 6f 74 65 57 |laceSing|leQuoteW|
|00005ab0| 69 74 68 54 77 6f 28 42 | 6f 75 6e 64 56 61 6c 75 |ithTwo(B|oundValu|
|00005ac0| 65 29 0d 0a 09 09 43 6f | 6d 70 61 72 69 73 69 6f |e)....Co|mparisio|
|00005ad0| 6e 4f 70 20 3d 20 22 22 | 20 2b 20 5b 63 6f 6d 70 |nOp = ""| + [comp|
|00005ae0| 61 72 69 73 69 6f 6e 4f | 70 5d 0d 0a 0d 0a 0d 0a |arisionO|p]......|
|00005af0| 09 09 43 6f 6c 54 79 70 | 65 20 3d 20 2d 31 0d 0a |..ColTyp|e = -1..|
|00005b00| 09 09 43 6f 6c 54 79 70 | 65 20 3d 20 5b 74 61 72 |..ColTyp|e = [tar|
|00005b10| 67 65 74 5d 2e 47 65 74 | 46 69 65 6c 64 28 42 6f |get].Get|Field(Bo|
|00005b20| 75 6e 64 43 6f 6c 75 6d | 6e 29 2e 54 79 70 65 0d |undColum|n).Type.|
|00005b30| 0a 0d 0a 09 09 69 66 28 | 49 6e 53 74 72 28 42 6f |.....if(|InStr(Bo|
|00005b40| 75 6e 64 43 6f 6c 75 6d | 6e 2c 22 20 22 29 20 41 |undColum|n," ") A|
|00005b50| 4e 44 20 28 52 69 67 68 | 74 28 42 6f 75 6e 64 43 |ND (Righ|t(BoundC|
|00005b60| 6f 6c 75 6d 6e 2c 31 29 | 20 3c 3e 20 22 5d 22 29 |olumn,1)| <> "]")|
|00005b70| 29 20 74 68 65 6e 0d 0a | 09 09 09 52 45 4d 20 63 |) then..|...REM c|
|00005b80| 68 65 63 6b 20 66 6f 72 | 20 74 61 62 6c 65 6e 61 |heck for| tablena|
|00005b90| 6d 65 2e 63 6f 6c 75 6d | 6e 0d 0a 09 09 09 6e 44 |me.colum|n.....nD|
|00005ba0| 6f 74 20 3d 20 49 6e 53 | 74 72 28 42 6f 75 6e 64 |ot = InS|tr(Bound|
|00005bb0| 43 6f 6c 75 6d 6e 2c 22 | 2e 22 29 0d 0a 09 09 09 |Column,"|.").....|
|00005bc0| 69 66 28 6e 44 6f 74 20 | 3e 20 30 29 20 74 68 65 |if(nDot |> 0) the|
|00005bd0| 6e 0d 0a 09 09 09 09 54 | 68 65 54 61 62 6c 65 4e |n......T|heTableN|
|00005be0| 61 6d 65 20 3d 20 4d 69 | 64 28 42 6f 75 6e 64 43 |ame = Mi|d(BoundC|
|00005bf0| 6f 6c 75 6d 6e 2c 31 2c | 20 6e 44 6f 74 29 0d 0a |olumn,1,| nDot)..|
|00005c00| 09 09 09 09 54 68 65 43 | 6f 6c 75 6d 6e 4e 61 6d |....TheC|olumnNam|
|00005c10| 65 20 3d 20 4d 69 64 28 | 42 6f 75 6e 64 43 6f 6c |e = Mid(|BoundCol|
|00005c20| 75 6d 6e 2c 6e 44 6f 74 | 20 2b 20 31 29 0d 0a 09 |umn,nDot| + 1)...|
|00005c30| 09 09 09 69 66 28 49 6e | 53 74 72 28 54 68 65 54 |...if(In|Str(TheT|
|00005c40| 61 62 6c 65 4e 61 6d 65 | 2c 22 20 22 29 20 41 4e |ableName|," ") AN|
|00005c50| 44 20 28 52 69 67 68 74 | 28 54 68 65 54 61 62 6c |D (Right|(TheTabl|
|00005c60| 65 4e 61 6d 65 2c 31 29 | 20 3c 3e 20 22 5d 22 29 |eName,1)| <> "]")|
|00005c70| 29 20 74 68 65 6e 0d 0a | 09 09 09 09 09 52 45 4d |) then..|.....REM|
|00005c80| 20 70 75 74 20 62 72 61 | 63 6b 65 74 73 20 6f 6e | put bra|ckets on|
|00005c90| 20 74 61 62 6c 65 20 6e | 61 6d 65 0d 0a 09 09 09 | table n|ame.....|
|00005ca0| 09 09 54 68 65 54 61 62 | 6c 65 4e 61 6d 65 20 3d |..TheTab|leName =|
|00005cb0| 20 22 5b 22 20 26 20 54 | 68 65 54 61 62 6c 65 6e | "[" & T|heTablen|
|00005cc0| 61 6d 65 20 26 20 22 5d | 22 0d 0a 09 09 09 09 65 |ame & "]|"......e|
|00005cd0| 6e 64 20 69 66 0d 0a 09 | 09 09 09 69 66 28 49 6e |nd if...|...if(In|
|00005ce0| 53 74 72 28 54 68 65 43 | 6f 6c 75 6d 6e 4e 61 6d |Str(TheC|olumnNam|
|00005cf0| 65 2c 22 20 22 29 29 20 | 74 68 65 6e 0d 0a 09 09 |e," ")) |then....|
|00005d00| 09 09 09 52 45 4d 20 70 | 75 74 20 62 72 61 63 6b |...REM p|ut brack|
|00005d10| 65 74 73 20 6f 6e 20 63 | 6f 6c 75 6d 6e 20 6e 61 |ets on c|olumn na|
|00005d20| 6d 65 0d 0a 09 09 09 09 | 09 54 68 65 43 6f 6c 75 |me......|.TheColu|
|00005d30| 6d 6e 4e 61 6d 65 20 3d | 20 22 5b 22 20 26 20 54 |mnName =| "[" & T|
|00005d40| 68 65 43 6f 6c 75 6d 6e | 4e 61 6d 65 20 26 20 22 |heColumn|Name & "|
|00005d50| 5d 22 0d 0a 09 09 09 09 | 65 6e 64 20 69 66 0d 0a |]"......|end if..|
|00005d60| 09 09 09 09 42 6f 75 6e | 64 43 6f 6c 75 6d 6e 20 |....Boun|dColumn |
|00005d70| 3d 20 54 68 65 54 61 62 | 6c 65 4e 61 6d 65 20 26 |= TheTab|leName &|
|00005d80| 20 22 2e 22 20 26 20 54 | 68 65 43 6f 6c 75 6d 6e | "." & T|heColumn|
|00005d90| 4e 61 6d 65 0d 0a 09 09 | 09 65 6c 73 65 0d 0a 09 |Name....|.else...|
|00005da0| 09 09 09 42 6f 75 6e 64 | 43 6f 6c 75 6d 6e 20 3d |...Bound|Column =|
|00005db0| 20 22 5b 22 20 26 20 42 | 6f 75 6e 64 43 6f 6c 75 | "[" & B|oundColu|
|00005dc0| 6d 6e 20 26 20 22 5d 22 | 0d 0a 09 09 09 65 6e 64 |mn & "]"|.....end|
|00005dd0| 20 69 66 0d 0a 09 09 65 | 6e 64 20 69 66 0d 0a 0d | if....e|nd if...|
|00005de0| 0a 09 09 69 66 28 28 28 | 22 22 20 26 20 42 6f 75 |...if(((|"" & Bou|
|00005df0| 6e 64 56 61 6c 75 65 29 | 20 3d 20 22 22 29 29 20 |ndValue)| = "")) |
|00005e00| 74 68 65 6e 0d 0a 09 09 | 09 52 45 4d 20 64 6f 6e |then....|.REM don|
|00005e10| 27 74 20 61 70 70 65 6e | 64 20 74 68 65 20 76 61 |'t appen|d the va|
|00005e20| 6c 75 65 2e 2e 49 74 20 | 69 73 20 64 6f 6e 27 74 |lue..It |is don't|
|00005e30| 20 63 61 72 65 20 63 61 | 73 65 2e 0d 0a 09 09 65 | care ca|se.....e|
|00005e40| 6c 73 65 69 66 20 28 28 | 52 65 71 75 65 73 74 2e |lseif ((|Request.|
|00005e50| 46 6f 72 6d 2e 4b 65 79 | 28 46 6f 72 6d 45 6c 65 |Form.Key|(FormEle|
|00005e60| 6d 65 6e 74 29 20 3d 20 | 22 22 29 20 41 4e 44 20 |ment) = |"") AND |
|00005e70| 28 42 69 6e 64 69 6e 67 | 54 79 70 65 3d 22 46 52 |(Binding|Type="FR|
|00005e80| 4d 22 29 29 20 74 68 65 | 6e 0d 0a 09 09 09 52 45 |M")) the|n.....RE|
|00005e90| 4d 20 4d 61 6b 65 20 53 | 75 72 65 20 74 68 65 20 |M Make S|ure the |
|00005ea0| 64 61 74 61 54 79 70 65 | 20 69 73 20 62 6f 6f 6c |dataType| is bool|
|00005eb0| 65 61 6e 0d 0a 09 09 09 | 69 66 20 28 43 6f 6c 54 |ean.....|if (ColT|
|00005ec0| 79 70 65 20 3d 20 31 31 | 29 20 74 68 65 6e 0d 0a |ype = 11|) then..|
|00005ed0| 09 09 09 09 69 66 20 28 | 43 6f 6c 43 6f 75 6e 74 |....if (|ColCount|
|00005ee0| 20 3c 3e 20 30 29 20 74 | 68 65 6e 0d 0a 09 09 09 | <> 0) t|hen.....|
|00005ef0| 09 09 57 68 65 72 65 20 | 3d 20 57 68 65 72 65 20 |..Where |= Where |
|00005f00| 26 20 22 20 22 20 26 20 | 5b 4c 6f 67 69 63 61 6c |& " " & |[Logical|
|00005f10| 4f 70 65 72 61 74 6f 72 | 5d 20 2b 20 22 20 22 0d |Operator|] + " ".|
|00005f20| 0a 09 09 09 09 65 6e 64 | 20 69 66 0d 0a 0d 0a 09 |.....end| if.....|
|00005f30| 09 09 09 57 68 65 72 65 | 20 3d 20 57 68 65 72 65 |...Where| = Where|
|00005f40| 20 26 20 22 28 22 20 26 | 20 42 6f 75 6e 64 43 6f | & "(" &| BoundCo|
|00005f50| 6c 75 6d 6e 20 2b 20 22 | 20 3d 20 30 29 22 0d 0a |lumn + "| = 0)"..|
|00005f60| 09 09 09 09 43 6f 6c 43 | 6f 75 6e 74 20 3d 20 43 |....ColC|ount = C|
|00005f70| 6f 6c 43 6f 75 6e 74 20 | 2b 20 31 0d 0a 09 09 09 |olCount |+ 1.....|
|00005f80| 65 6e 64 20 69 66 0d 0a | 09 09 65 6c 73 65 0d 0a |end if..|..else..|
|00005f90| 09 09 09 69 66 20 28 43 | 6f 6c 43 6f 75 6e 74 20 |...if (C|olCount |
|00005fa0| 3c 3e 20 30 29 20 74 68 | 65 6e 0d 0a 09 09 09 09 |<> 0) th|en......|
|00005fb0| 57 68 65 72 65 20 3d 20 | 57 68 65 72 65 20 2b 20 |Where = |Where + |
|00005fc0| 22 20 22 20 2b 20 5b 4c | 6f 67 69 63 61 6c 4f 70 |" " + [L|ogicalOp|
|00005fd0| 65 72 61 74 6f 72 5d 20 | 2b 20 22 20 22 0d 0a 09 |erator] |+ " "...|
|00005fe0| 09 09 65 6e 64 20 69 66 | 0d 0a 0d 0a 09 09 09 53 |..end if|.......S|
|00005ff0| 65 6c 65 63 74 20 43 61 | 73 65 20 43 6f 6c 54 79 |elect Ca|se ColTy|
|00006000| 70 65 0d 0a 09 09 09 09 | 43 61 73 65 20 37 3a 09 |pe......|Case 7:.|
|00006010| 09 52 45 4d 20 61 64 44 | 61 74 65 0d 0a 09 09 09 |.REM adD|ate.....|
|00006020| 09 43 61 73 65 20 31 33 | 33 3a 09 52 45 4d 20 61 |.Case 13|3:.REM a|
|00006030| 64 44 42 44 61 74 65 0d | 0a 09 09 09 09 43 61 73 |dDBDate.|.....Cas|
|00006040| 65 20 31 33 34 3a 09 52 | 45 4d 20 61 64 44 42 54 |e 134:.R|EM adDBT|
|00006050| 69 6d 65 0d 0a 09 09 09 | 09 43 61 73 65 20 31 33 |ime.....|.Case 13|
|00006060| 35 3a 09 52 45 4d 20 61 | 64 44 42 54 69 6d 65 53 |5:.REM a|dDBTimeS|
|00006070| 74 61 6d 70 0d 0a 09 09 | 09 09 09 49 66 20 43 6f |tamp....|...If Co|
|00006080| 6d 70 61 72 69 73 69 6f | 6e 4f 70 20 3c 3e 20 22 |mparisio|nOp <> "|
|00006090| 22 20 54 68 65 6e 0d 0a | 09 09 09 09 09 09 49 66 |" Then..|......If|
|000060a0| 20 43 6f 6d 70 61 72 69 | 73 69 6f 6e 4f 70 20 3d | Compari|sionOp =|
|000060b0| 20 22 62 65 67 69 6e 73 | 20 77 69 74 68 22 20 54 | "begins| with" T|
|000060c0| 68 65 6e 0d 0a 09 09 09 | 09 09 09 09 57 68 65 72 |hen.....|....Wher|
|000060d0| 65 20 3d 20 57 68 65 72 | 65 20 26 20 22 28 22 20 |e = Wher|e & "(" |
|000060e0| 26 20 42 6f 75 6e 64 43 | 6f 6c 75 6d 6e 20 20 26 |& BoundC|olumn &|
|000060f0| 20 22 20 4c 49 4b 45 20 | 23 22 20 26 20 42 6f 75 | " LIKE |#" & Bou|
|00006100| 6e 64 56 61 6c 75 65 20 | 26 20 20 22 2a 23 29 22 |ndValue |& "*#)"|
|00006110| 0d 0a 09 09 09 09 09 09 | 45 6c 73 65 49 66 20 43 |........|ElseIf C|
|00006120| 6f 6d 70 61 72 69 73 69 | 6f 6e 4f 70 20 3d 20 22 |omparisi|onOp = "|
|00006130| 63 6f 6e 74 61 69 6e 73 | 22 20 54 68 65 6e 0d 0a |contains|" Then..|
|00006140| 09 09 09 09 09 09 09 57 | 68 65 72 65 20 3d 20 57 |.......W|here = W|
|00006150| 68 65 72 65 20 26 20 22 | 28 22 20 26 20 42 6f 75 |here & "|(" & Bou|
|00006160| 6e 64 43 6f 6c 75 6d 6e | 20 20 26 20 22 20 4c 49 |ndColumn| & " LI|
|00006170| 4b 45 20 23 25 22 20 26 | 20 42 6f 75 6e 64 56 61 |KE #%" &| BoundVa|
|00006180| 6c 75 65 20 26 20 20 22 | 25 23 29 22 0d 0a 09 09 |lue & "|%#)"....|
|00006190| 09 09 09 09 45 6c 73 65 | 49 66 20 43 6f 6d 70 61 |....Else|If Compa|
|000061a0| 72 69 73 69 6f 6e 4f 70 | 20 3d 20 22 65 6e 64 73 |risionOp| = "ends|
|000061b0| 20 77 69 74 68 22 20 54 | 68 65 6e 0d 0a 09 09 09 | with" T|hen.....|
|000061c0| 09 09 09 09 57 68 65 72 | 65 20 3d 20 57 68 65 72 |....Wher|e = Wher|
|000061d0| 65 20 26 20 22 28 22 20 | 26 20 42 6f 75 6e 64 43 |e & "(" |& BoundC|
|000061e0| 6f 6c 75 6d 6e 20 20 26 | 20 22 20 4c 49 4b 45 20 |olumn &| " LIKE |
|000061f0| 23 25 22 20 26 20 42 6f | 75 6e 64 56 61 6c 75 65 |#%" & Bo|undValue|
|00006200| 20 26 20 20 22 23 29 22 | 0d 0a 09 09 09 09 09 09 | & "#)"|........|
|00006210| 45 6c 73 65 49 66 20 43 | 6f 6d 70 61 72 69 73 69 |ElseIf C|omparisi|
|00006220| 6f 6e 4f 70 20 3d 20 22 | 65 71 75 61 6c 20 74 6f |onOp = "|equal to|
|00006230| 22 20 54 68 65 6e 0d 0a | 09 09 09 09 09 09 09 57 |" Then..|.......W|
|00006240| 68 65 72 65 20 3d 20 57 | 68 65 72 65 20 26 20 22 |here = W|here & "|
|00006250| 28 22 20 26 20 42 6f 75 | 6e 64 43 6f 6c 75 6d 6e |(" & Bou|ndColumn|
|00006260| 20 20 26 20 22 20 3d 20 | 23 22 20 26 20 42 6f 75 | & " = |#" & Bou|
|00006270| 6e 64 56 61 6c 75 65 20 | 26 20 20 22 23 29 22 0d |ndValue |& "#)".|
|00006280| 0a 09 09 09 09 09 09 45 | 6c 73 65 0d 0a 09 09 09 |.......E|lse.....|
|00006290| 09 09 09 09 57 68 65 72 | 65 20 3d 20 57 68 65 72 |....Wher|e = Wher|
|000062a0| 65 20 26 20 22 28 22 20 | 26 20 42 6f 75 6e 64 43 |e & "(" |& BoundC|
|000062b0| 6f 6c 75 6d 6e 20 20 26 | 20 22 20 3d 20 23 22 20 |olumn &| " = #" |
|000062c0| 26 20 42 6f 75 6e 64 56 | 61 6c 75 65 20 26 20 20 |& BoundV|alue & |
|000062d0| 22 23 29 22 09 0d 0a 09 | 09 09 09 09 09 45 6e 64 |"#)"....|.....End|
|000062e0| 20 49 66 0d 0a 09 09 09 | 09 09 45 6c 73 65 0d 0a | If.....|..Else..|
|000062f0| 09 09 09 09 09 09 09 57 | 68 65 72 65 20 3d 20 57 |.......W|here = W|
|00006300| 68 65 72 65 20 26 20 22 | 28 22 20 26 20 42 6f 75 |here & "|(" & Bou|
|00006310| 6e 64 43 6f 6c 75 6d 6e | 20 20 26 20 22 20 3d 20 |ndColumn| & " = |
|00006320| 23 22 20 26 20 42 6f 75 | 6e 64 56 61 6c 75 65 20 |#" & Bou|ndValue |
|00006330| 26 20 20 22 23 29 22 09 | 0d 0a 09 09 09 09 09 45 |& "#)".|.......E|
|00006340| 6e 64 20 49 66 0d 0a 09 | 09 09 09 43 61 73 65 20 |nd If...|...Case |
|00006350| 45 6c 73 65 3a 0d 0a 09 | 09 09 09 09 49 66 20 43 |Else:...|....If C|
|00006360| 6f 6d 70 61 72 69 73 69 | 6f 6e 4f 70 20 3c 3e 20 |omparisi|onOp <> |
|00006370| 22 22 20 54 68 65 6e 0d | 0a 09 09 09 09 09 09 49 |"" Then.|.......I|
|00006380| 66 20 43 6f 6d 70 61 72 | 69 73 69 6f 6e 4f 70 20 |f Compar|isionOp |
|00006390| 3d 20 22 62 65 67 69 6e | 73 20 77 69 74 68 22 20 |= "begin|s with" |
|000063a0| 54 68 65 6e 0d 0a 09 09 | 09 09 09 09 09 57 68 65 |Then....|.....Whe|
|000063b0| 72 65 20 3d 20 57 68 65 | 72 65 20 26 20 22 28 22 |re = Whe|re & "("|
|000063c0| 20 26 20 42 6f 75 6e 64 | 43 6f 6c 75 6d 6e 20 20 | & Bound|Column |
|000063d0| 26 20 22 20 4c 49 4b 45 | 20 27 22 20 26 20 42 6f |& " LIKE| '" & Bo|
|000063e0| 75 6e 64 56 61 6c 75 65 | 20 26 20 20 22 2a 27 29 |undValue| & "*')|
|000063f0| 22 0d 0a 09 09 09 09 09 | 09 45 6c 73 65 49 66 20 |".......|.ElseIf |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
